×
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

Accessing Tools->Spreadsheet in NX model using UFUNC or NXOpen

Accessing Tools->Spreadsheet in NX model using UFUNC or NXOpen

Accessing Tools->Spreadsheet in NX model using UFUNC or NXOpen

(OP)
Hi,
In one of the NX assembly, I have different expressions which rules the model parameters. These expressions values are the results from the formulas embedded in Tools->Expressions. Now I'm trying to develop a code to access this Tools->Spreadsheet using C/C++ functionalities and update the spreadsheet's values from secondary spec values. As I understood from GTAC, there is no API to access Tools->Spreadsheet. Do any of you knows any method to solve the situation I'm facing? Thanks in advance.
Regards, Harsha

RE: Accessing Tools->Spreadsheet in NX model using UFUNC or NXOpen

You cannot manipulate the modeling spreadsheet directly; but you can extract it to a file, manipulate it, and restore it to the NX file. The functions to extract/restore the spreadsheet are:
UF_XS_extract_spreadsheet
UF_XS_store_spreadsheet

www.nxjournaling.com

RE: Accessing Tools->Spreadsheet in NX model using UFUNC or NXOpen

The so-called embedded 'NX Spreadsheet' is ONLY a spreadsheet in the sense that we use Excel as a sort of 'user interface' allowing the user to easily edit and manipulate expressions using a tabular metaphor. Once the spreadsheet is closed, the data that was seen when the spreadsheet was open is simply saved in an NX data record which is NOT actually a spreadsheet file but rather something that we're simply using as way to save the data for if and when the NX Spreadsheet is reactivated in a later session. But when it's not active, it has no link to the expressions nor would editing that data, if you could, actually cause any aspect of the NX model to update.

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

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

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