Skip to main content
DJNewman
DJNewman18-Opal
18-Opal
January 19, 2022
Question

Importing Data from Excel to Mathcad

  • January 19, 2022
  • 2 replies
  • 10009 views

This PTC Mathcad Prime worksheet explores two options for importing data from an external Excel file into Mathcad. These two options are the Excel Component and the READEXCEL function .

This worksheet is partitioned into two sections. Within each section, we will calculate the surface area of a threaded bolt for electro-plating using data imported using the two options mentioned above. Please note that this is not intended to be an in-depth tutorial, and therefore won't provide details on every mouse click and keyboard entry. There are examples available in the Help Center, so if you find yourself needing a little extra explanation, that will be a great place to start. Direct links to specific features will be added in this document to help you find more information on that specific topic.

 

This Mathcad worksheet was made in Mathcad Prime 7 and then updated to Mathcad Prime 9, and uses Mathcad premium functionality. The .zip includes the Mathcad worksheet and an Excel spreadsheet that should be saved in the same directory.

    2 replies

    K
    KevinFinity12-Amethyst
    12-Amethyst
    January 26, 2022

    For the record I have found that excel components can corrupt the MathCAD file, making it unable to be opened. I don't know if this has been solved in Prime7, but it was a problem in Prime 3.5.  I prefer to use excel component only for generating outputs, and READEXCEL for reading inputs. 

     

    I encountered this problem when I was trying to store large data tables as excel components. 

    V
    24-Ruby III
    VladimirN24-Ruby III
    24-Ruby III
    January 26, 2022

    And what version of MS Excel did you use?

    K
    KevinFinity12-Amethyst
    12-Amethyst
    January 26, 2022

    I don't know - it was on an old computer that I no longer have access to. 

     

    The size of one table was 72 rows x 49 columns and another was 80 x 20, but I think that I also had more tables, and the excel components had formatting. Formatting takes up a lot of unnecessary memory. 

     

    Excel component is still handier than the new Combo Box feature, though.

    H
    HS_102064231-Visitor
    1-Visitor
    February 25, 2022
    @DJNewman wrote:

    This PTC Mathcad Prime worksheet explores two options for importing data from an external Excel file into Mathcad. These two options are the Excel Component and the READEXCEL function .

    This worksheet is partitioned into two sections. Within each section, we will calculate the surface area of a threaded bolt for electro-plating using data imported using the two options mentioned above. Please note that this is not intended to be an in-depth tutorial, and therefore won't provide details on every mouse click and keyboard entry. There are examples available in the Help Center, so if you find yourself needing a little extra explanation, that will be a great place to start. Direct links to specific features will be added in this document to help you find more information on that specific topic.

     

    This Mathcad worksheet was made in Mathcad Prime 7 and uses Mathcad premium functionality. The .zip includes the Mathcad worksheet and an Excel spreadsheet that should be saved in the same directory.

    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?

    DJNewman
    DJNewman18-OpalAuthor
    18-Opal
    February 25, 2022

    Hello,

    I'm not sure how you reached that conclusion? The Excel file included in the .zip with the tutorial worksheet is, in fact, an .xlsx file. (The .zip contains thread.xlsx and Importing Data from Excel.mcdx ).

     

    If you want multiple Excel sheets embedded, then just make multiple Excel components in the same Mathcad worksheet. I think that's what you're getting at?

    PTC Marketer Creo and Mathcad. I run their YouTube channels, some Creo campaigns, and all Mathcad campaigns and communications.
    Terms & ConditionsCookie settingsAccessibility statement