×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

PartFamily Template > NXOpen > VB.NET > open & read cells in the internal excelbook

PartFamily Template > NXOpen > VB.NET > open & read cells in the internal excelbook

PartFamily Template > NXOpen > VB.NET > open & read cells in the internal excelbook

(OP)
Hi -
In NX >
Does someone here know if it will be possible to read values from the cell's in the internal excelsheet, in a partfamily template.
I know how to read and write in a excel sheet in OS - but I do not know how to access the excelsheet in a partfamily template.
I'm using VB.NET....

lklo

RE: PartFamily Template > NXOpen > VB.NET > open & read cells in the internal excelbook

Yes, it is possible. You need to extract the spreadsheet to query or modify it. This link has some code that looks at a spreadsheet controlled tabular note, but the workflow would be similar for the modeling or part family spreadsheet.

www.nxjournaling.com

RE: PartFamily Template > NXOpen > VB.NET > open & read cells in the internal excelbook

(OP)
Cowski - thank you so much for this...
In near future I´m gonna program a small too for authoring PTB files (used in routing environment).
My goal is to be able to create a PTB file in one shot , all info and data is stored in the family master part.
But seems to be possible, because NXOpen can extract the internal excel sheet by using:
I will give it a try...

But I need to find the spreadSheetTag
I will try find the syntax for that...

CODE -->

Dim tempFile As String = "C:\Temp\tempToDelete.xlsx" 

CODE -->

spreadSheetTag = ????? 

CODE -->

Dim ssObj As NXObject
ssObj = Utilities.NXObjectManager.Get(spreadSheetTag) 

CODE -->

theUfSession.Xs.ExtractSpreadsheet(ssObj.Name, tempFile) 


lklo

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources