Skip to main content
1-Visitor
April 14, 2014
Solved

Excel - Importing names of worksheets

  • April 14, 2014
  • 3 replies
  • 1626 views

I am trying to import data into Mathcad from Excel file by using file reading function. I have data on multiple worksheets in that excel spreadsheet file. I am able to import the data successfully. Along with data, I want to import name of that excel worksheet as well. Is there any way to import names of worksheets present in the excel file?

Best answer by Werner_E

I guess this is what you are looking for: http://communities.ptc.com/message/167861#167861

3 replies

Werner_E25-Diamond IAnswer
25-Diamond I
April 14, 2014

I guess this is what you are looking for: http://communities.ptc.com/message/167861#167861

1-Visitor
April 15, 2014

Werner has pointed you to a thread we worked on a while back. The worksheet maybe work depending on what version of Mathcad and Excel you are using.

Let us know if you have any issues.

1-Visitor
April 15, 2014

That was precise what I was looking for. I had to make a few changes to the scipt but now its working as intended. Thank you Werner and Mike.