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 TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

ug_excel_read different sheets in the same file

Status
Not open for further replies.

kk72

Mechanical
Joined
Aug 24, 2011
Messages
2
Location
US
Hi all

Is it possible to read cell from different sheets in a file? e.g. cell A1 from Sheet1 and cell A2 from Sheet2. I know the format for reading off Sheet1 is
ug_excel_read("c:\path\filename.xls", "cell" ).
If it is possible what is the format to read from other sheets?
 
Spontaneous thought: Have you tried calling the following?

Code:
ug_excel_read("c:\path\filename.xls", "sheetname!cell")

This is just a wild guess, as I am not very familiar with the function.



Marc
NX Software Developer
 
I have just confirmed my above post. This does work.

Marc
NX Software Developer
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top