Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations JAE 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
Joined
Apr 23, 2012
Messages
7
Location
US
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?
 
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

Back
Top