How to read sheet 2 or higher of Excel file from within Mathcad

Forum|Forum|15 years ago
October 20, 2010
1 reply
3300 views

1) Can someone tells me how can we read "sheet2" or higher of an excel file directly from mathcad.

For example, I can read an excel file with a commad like READFILE("c:\myfile.xls","excel") but I am getting the sheet1 only.

What should I do to be able to read sheet2 or higher from myfile.xls

2) Yesterday I put a question and I received a correct answer. I cannot find how to set that the question has been correctly answered !

Sorry but I rarely use the PTC community discussion forum

Thank you

Other

Best answer by MikeArmstrong

The attached scripted component does exactly what you want.

Change the file path to suit your file name - make sure its exactly as your file including the Excel version. Right click the text box click edit script and select the tick at the top. The data should then be extracted as per "Pages" at the top of the sheet.

2) Yesterday I put a question and I received a correct answer. I cannot find how to set that the question has been correctly answered !
Sorry but I rarely use the PTC community discussion forum

I think you select the post where the answer and the site gives you a option to state that the post is the answer.

Mike

M

MikeArmstrong

Answer

1-Visitor

The attached scripted component does exactly what you want.

Change the file path to suit your file name - make sure its exactly as your file including the Excel version. Right click the text box click edit script and select the tick at the top. The data should then be extracted as per "Pages" at the top of the sheet.

2) Yesterday I put a question and I received a correct answer. I cannot find how to set that the question has been correctly answered !
Sorry but I rarely use the PTC community discussion forum

I think you select the post where the answer and the site gives you a option to state that the post is the answer.

Mike

1_MC_SCRITPED-OBJECT_COMPONENT_EXCEL_READFILE-mcd.zip