Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update part expressions from Excel sheet with NX Open

Status
Not open for further replies.

LovasLev

Mechanical
Joined
Nov 28, 2020
Messages
1
Location
HU
Hi,

I started to learn/use NX Open a few weeks ago, so this maybe would be a rookie question, but I would like to make a .dll file with NX Open in Visual Basic which reads an Excel sheet. The Excel sheet contains the filename and the parameters. I want it to update expressions of the part which's location is written in the sheet to those values which are in the excel. I attach a snapshot how the sheet would look like.
excel_example_aql91v.png


So how could I do it? Is this even possible?
 
It is certainly possible. What version of NX are you using? The NXOpen API in newer versions adds a spreadsheet manager class that makes working with Excel files easier.

Also, note that in the expression editor you can export the expressions to a plain text file. This file can be modified and imported to create/update expressions.

www.nxjournaling.com
 
Fyi,
You can create expressions in NX , without Journals, that reads external Excel sheets.
so if the job is "simple" and not "everyday" it might be simpler to do this .

Regards,
Tomas

 
That's a good point, Toost.
Also, you can make use of the modeling spreadsheet that is embedded in the NX file. I usually forget it is there, but I have seen a few models that make good use of it.

www.nxjournaling.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top