×
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

Read data from internal spreadsheet

Read data from internal spreadsheet

Read data from internal spreadsheet

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

RE: Read data from internal spreadsheet

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

RE: Read data from internal spreadsheet

(OP)
Thanks, fast answer smile

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

RE: Read data from internal spreadsheet

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

RE: Read data from internal spreadsheet

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

RE: Read data from internal spreadsheet

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.

RE: Read data from internal spreadsheet

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

RE: Read data from internal spreadsheet

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

RE: Read data from internal spreadsheet

(OP)
And next how to connect "spreadsheet" table with features ?

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

RE: Read data from internal spreadsheet

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.

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