NXOpen reading input from Excel
NXOpen reading input from Excel
(OP)
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.
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.





RE: NXOpen reading input from Excel
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.
RE: NXOpen reading input from Excel
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!
RE: NXOpen reading input from Excel
The program is in VB and I am on NX7.5.
RE: NXOpen reading input from Excel
...\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
RE: NXOpen reading input from Excel
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.
RE: NXOpen reading input from Excel
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
RE: NXOpen reading input from Excel
Thanks again.