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

[HarshaKN]

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

 

[cowski]

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

 

[JohnRBaker]

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.