Skip to main content
D
dabber1-Visitor
1-Visitor
October 3, 2011
Solved

Accessing Multiple Excel Worksheets using Component

  • October 3, 2011
  • 2 replies
  • 3715 views

How can I access an Excel worksheet in an Excel file with multiple worksheets? I have tried using both the data import wizard and the Microsoft Excel component with no success. I have also tried using the Insert/File Input dialog box choosing the Microsoft Excel option but it didn't work.

The Data Import Wizard and the Insert/File Input options will allow you to select a file and file type (i.e., Microsoft Excel) but when I select a workbook with multiple worksheets I can't do anything. For both options is a drop-down menu for the worksheet but there are no menu selections.

I have looked in the Help files but for this case the help files don't help

Best answer by VladimirN

Hello!

It is necessary for you to use additional record in a type "Sheet№!Cell".

Excel_example.jpg

Excel2.jpg

P.S. Which version of Mathcad you use?

2 replies

V
VladimirN24-Ruby IIIAnswer
24-Ruby III
October 4, 2011

Hello!

It is necessary for you to use additional record in a type "Sheet№!Cell".

Excel_example.jpg

Excel2.jpg

P.S. Which version of Mathcad you use?

M
MikeArmstrong1-Visitor
1-Visitor
October 4, 2011

As Vladimir has shown above, there is a built in function which allows you to call up individual Excel worksheets. The only issue is that you have to know the worksheet names.

Mike

M
MikeArmstrong1-Visitor
1-Visitor
October 4, 2011

I forgot to mention that I have recently produced a scripted component which will automatically pull Excel worksheets names which could help.

Search under my name - it was Raiko's thread.

Mike

D
dabber1-VisitorAuthor
1-Visitor
October 4, 2011

Thanks Gents. I had forgotten about the READEXCEL function. I was trying to do it using the data import wizard since it says that you can read in excel files and the user interface infers that you can access different worksheets.

To answer Vladimir's question, I am using Mathcad 15.

Terms & ConditionsAccessibility statement