NXOpen reading input from Excel 2

[edgray]

I am interested in adding an option to my current part building program to take input from an Excel file.

Currently the program guides the user through selection of existing parts to be imported (sort of like a UDF)and asking for modification inputs.

I would like to add an option to select an Excel file which would have all the sub parts and modifiers defined. The program could then be run in nearly batch mode.

I am hoping to be able to call out the file name and cell locations to pull the inputs.

Thank you.

 

[JohnRBaker]

If you write an NX Open custom application, there should be NO trouble whatsoever doing something like that.

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:

To an Engineer, the glass is twice as big as it needs to be.

 

[edgray]

Where might I find examples of the code and the required declarations?

I am a self taught NX Open VB programmer and still have a shallow understanding of the real guts of VB and its OOP brethren.

So far I have made substantial progress working from journal files and examples in the GTAC code examples.

Any help would be appreciated.

Thank you!

 

[edgray]

Oops I should have given some of the particulars about my environment.

The program is in VB and I am on NX7.5.

 

[markrief]

Take a look at this sample that reads an excel spreadsheet:
...\UGOPEN\SampleNXOpenApplications\.NET\CAM\AssignAttributesForTooltips.vb
...\UGOPEN\SampleNXOpenApplications\.NET\CAM\AssignAttributesForTooltips_sample.xlsx

This may have been added after 7.5 - if you don't see it, GTAC can send you a copy.


Mark Rief
Product Manager
Siemens PLM

 

[edgray]

Thank you for your reply.
This appears to be a path in a folder structure. Is that in the GTAC solutions center?
I tried to search on many of the words in the paths you listed but got no hits.
I also tried searching on the word "excel", but those programs are writing out to Excel, not reading from.
How do I find your items in the solution center.

 

[cowski]

These are samples shipped with NX. You can find the ones Mark mentioned above plus many more at <NX install folder>\UGOPEN\SampleNXOpenApplications\.NET.

A common location for the NX 7.5 install folder would be: C:\Program Files\UGS\NX 7.5, but it may be different for you.

www.nxjournaling.com

 

[edgray]

Thanks to both. I found the location but they are not there. I will contact GTAC.

Thanks again.