Update part expressions from Excel sheet with NX Open

[LovasLev]

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.

So how could I do it? Is this even possible?

 

[cowski]

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

 

[Toost]

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

 

[cowski]

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