Problem with inserting excel data in Mathcad

richardm55 · ‎Jul 14, 2019

I use Mathcad 15 and when I tried to insert excel file:

From menu Insert and choose Data and then File Input
In File Input window I choose Microsoft Excel
Browsing file location and ticked use relative file path
And then pressed button Later and went to another window
In the field Worksheet when I opened list it was nothing there
It was also nothing at field Named Range

How can I chose Worksheet from excel file when I got nothing to select?

Maybe Mathcad does not see excel file?

Any tips or advice?

Any help will be welcome.

Thank you in advance

Werner_E · ‎Jul 14, 2019

Guess it was a "newer" xlsx-file.

You may try to save the Excel file to an older format (*.xls)

But even though you can't select the worksheet name the excel data of the primary one should show up in mathcad when you assign the component to a variable.

richardm55 · ‎Jul 15, 2019

Yes, I use newer Excel with extension xlsx. I will try with xls extension then.

What you said means that I can not use excel file as data source with more than one worksheet and if I even use it will always take primary one?

Werner_E · ‎Jul 15, 2019

@richardm55 wrote:

Yes, I use newer Excel with extension xlsx. I will try with xls extension then.

What you said means that I can not use excel file as data source with more than one worksheet and if I even use it will always take primary one?

No, or at least I am not sure. I know that I could chose the worksheet when using an Excel sheet in older format.

I am not sure about the xlsx files - I just gave it a try after I read your question and also got a blank when it came to the point where normally could chose the sheet. In the other other hand I was trying with an Excel file consisting of just 1 sheet anyway.

I usually read in data from Excel sheets (which I do very rarely) using the READEXCEL command which gives me all the flexibility I need.

You may also think about embedding the Excel sheet using Mathcads Excel component - a method I don't like as it blows up the worksheet, makes it slower and means that the Excel sheet can't be easily changed.

tietjee · ‎Jul 15, 2019

The best method to import an excel spreadsheet to use the READEXCEL command. This gives the most options on the spreadsheet, worksheet and cell can be selected. I have found, importing multiple spreadsheet/worksheets is best done using a nested matrix.

Hope this helps.

SteenGroðe · ‎Jul 16, 2019

The Excel component still works in MC15M050 (I still see any reason to change to Prime so I have no idea if it will work there) also with xlsx files. Just one thing you need to beawre of: Excel needs to run in the background before you connect to a sheet (or make a new). I may work without, but not in my case. My system is Lenovo x270, Windows 10 and M$ off latest updates PS It is even rare I fire up v15 despite a few fixes since v11.2 I still prefer that version.