×
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

NXOpen reading input from Excel

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.

RE: NXOpen reading input from Excel

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.

RE: NXOpen reading input from Excel

(OP)
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!

RE: NXOpen reading input from Excel

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

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

RE: NXOpen reading input from Excel

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

RE: NXOpen reading input from Excel

(OP)
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.

RE: NXOpen reading input from Excel

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

RE: NXOpen reading input from Excel

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

Thanks again.

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