Read data from internal spreadsheet

[zanew12]

Is there a possibility to read data from internal spreadsheet like to reading data from external spreadsheet using command: ug_cell_read("ext file", XX)
So i could have my excel table inside .prt file.

 

[carliro]

Yes, try to go to Tools-> Spreadsheet and it opens the .xls from UG.

 

[zanew12]

Thanks, fast answer

But next how to use command ug_cell_read(????, XX)
what i should write in path "?????"

 

[carliro]

I have never used that... what it does?

 

[zanew12]

its take a parameters to model directly from excel file. now i want to change external excel to internal in prt.

 

[cowski]

This thread may help:
thread561-328366

www.nxjournaling.com

 

[JohnRBaker]

Technically, there is NO 'internal spreadsheet'. Rather there is a data record inside of an NX Part file which can be used to store the contents of a spreadsheet and when you launch the spreadsheet from inside of NX this data is used to populate the sheet once it's open. However, once you close the spreadsheet launched from within NX the spreadsheet itself goes away and only the data record remains, which is static. That is, it can't be accessed or updated until the spreadsheet is relaunched. Therefore, using commands like 'ug_cell_read' is of no value since there is NO 'spreadsheet' there to be read.

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.

 

[zanew12]

Thank you.
For me its OK, because i will change these parameter only by open "spreadsheet", changing in table, and then 'Update NX Part'.

But I still dont know how to use this command "ug_cell_read" directly to "internal spreadsheet". Because I dont use A and B column (parameter and value) But i need put a huge table like (B2:R70).

So i need to know "path" for my expression command:
a=ug_cell_read("path","cell")
where a is used in feature modeling,
"cell" is taken now from external excel and i want to use internal spreadsheet (example:F37)

And second question:
Is there no problem with UG7,5 spreadsheet and excel_2010?

 

[carliro]

Hi Guys, one more question according to the topic.

When I have excell open from NX and standalone .xls file is it possible to connect those two files with somekind of formula so the changes in outside .xls will for changes in NX .xls?

I wish to have something like this for filling up tables in drawings.

thx
Carliro

 

[zanew12]

And next how to connect "spreadsheet" table with features ?

EXCEL (table)-> SPREADSHEET (table)-> FEATURE (number from spreadsheet table)

 

[JohnRBaker]

The KF spreadsheet commands used by the Expression system, such as 'ug_cell_read', can ONLY access an EXTERNAL spreadsheet. The so-called 'internal spreadsheet' is only accessible while it is 'open', during which time NX is in a 'paused' state and not available for any interactive tasks.

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.