Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X
I use Mathcad 15 and when I tried to insert excel file:
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
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.
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?
@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.
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.