Skip to main content
Y
Yunus_Demirol8-Gravel
8-Gravel
January 10, 2023
Solved

excel data to table

  • January 10, 2023
  • 3 replies
  • 3827 views

Hello everyone,

 

I want to import excel data to a table that has names and units... I'm adding the excel data and Mathcad file.

 

 

Best answer by Fred_Kohlhepp

If you (in the EXCEL file) select and copy only the numbers, then paste them into Mathcad, Prime will create a table with the numbers but with un-declared variable names and units.  You can then fill in the names and unit values and the table columns will work like vectors in Mathcad.  An example is attached (Prime 8).  Your example (with multiple columns with the same names would be challenging, and using the same calculations with a different set of data would be an issue.

3 replies

W
Werner_E25-Diamond I
25-Diamond I
January 10, 2023

Maybe the attached file can be of any help

    T
    21-Topaz II
    terryhendicott21-Topaz II
    21-Topaz II
    January 11, 2023

    Hi,

    It is easy to multiply the excelread statement by the expected unit.

    Capture.JPG

    When augmenting and stacking matrices the rows of each augment and columns of each stack should match

    Capture2.JPG

    This gets the required matrix.  It is not an input table.

    Capture3.JPG

    Cheers

    Terry

      W
      Werner_E25-Diamond I
      25-Diamond I
      January 11, 2023

      Yes, but is looks like the desired unit is mm, not m.

      And as can be seen in the sheet I posted above, you have to make a compromise - either a text header or the preferred unit showing or a table without units at all 😞

        F
        Fred_Kohlhepp23-Emerald IAnswer
        23-Emerald I
        January 12, 2023

        If you (in the EXCEL file) select and copy only the numbers, then paste them into Mathcad, Prime will create a table with the numbers but with un-declared variable names and units.  You can then fill in the names and unit values and the table columns will work like vectors in Mathcad.  An example is attached (Prime 8).  Your example (with multiple columns with the same names would be challenging, and using the same calculations with a different set of data would be an issue.

          Terms & ConditionsCookie settingsAccessibility statement