Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I get "ug_cell_read" to read a cell in a specific Excel Tab?

Status
Not open for further replies.

dallas2000

Mechanical
Apr 23, 2012
7
How do I get "ug_cell_read" to read a specific cell in a specific Excel Tab? The Excel spreadsheet I am reading into an expression in NX 7.5 has several named tabs. I want "ug_cell_read" to look at a specific cell in a specific tab in my spreadsheet. What is the syntax for doing that if it can be done?
 
Replies continue below

Recommended for you

I should have said a specific cell on a specific sheet with Excell.
 
You can reference a specific cell just like Excel does when it references between sheets... Just add the specific sheet name right before the cell reference, with an exclamation point between them.

[pre]ug_cell_read( "D:\testing\tba_test.xlsx", "Eng-Tips Rules!B2" )[/pre]

Does that make sense?

Taylor Anderson
NX Product Manager, Knowledge Reuse and NX Design
Product Engineering Software
Siemens Product Lifecycle Management Software Inc.
(Phoenix, Arizona)
 
Thanks, Taylor Anderson! I just needed to take out the apostrophies that Excel puts in before and after the sheet name and everything worked just fine.
 
Great. Glad that's working for you!

Taylor Anderson
NX Product Manager, Knowledge Reuse and NX Design
Product Engineering Software
Siemens Product Lifecycle Management Software Inc.
(Phoenix, Arizona)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor