Skip to main content
R
richardm551-Visitor
1-Visitor
July 14, 2019
Question

Problem with inserting excel data in Mathcad

  • July 14, 2019
  • 2 replies
  • 3693 views

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

  1. From menu Insert and choose Data and then File Input
  2. In File Input window I choose Microsoft Excel
  3. Browsing file location and ticked use relative file path
  4. And then pressed button Later and went to another window
  5. In the field Worksheet when I opened list it was nothing there
  6. 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

2 replies

W
Werner_E25-Diamond I
25-Diamond I
July 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.

R
richardm551-VisitorAuthor
1-Visitor
July 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?

W
Werner_E25-Diamond I
25-Diamond I
July 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.

 

S
SteenGroðe10-Marble
10-Marble
July 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.
Terms & ConditionsAccessibility statement