Skip to main content
V
VR_97819596-Contributor
6-Contributor
April 10, 2021
Question

Excel Worksheet Import

  • April 10, 2021
  • 4 replies
  • 1941 views

How can I import XML data into Mathcad 

 

I want to parse and map date into a vector or matrix for an XML data

 

Vic

4 replies

F
Fred_Kohlhepp23-Emerald I
23-Emerald I
April 10, 2021

Have you looked?  Mathcad can read a file.  Prime will embed an EXCEL file component in the sheet.

W
Werner_E25-Diamond I
25-Diamond I
April 10, 2021

Your subject says "Excel" but in the body you write about XML ??

Excel should be no problem as Mathcad can read and embed Excel files out of the box.

Concerning XML you'd be forced to write your own parser in Mathcad.

T
21-Topaz II
terryhendicott21-Topaz II
21-Topaz II
April 12, 2021

Hi,

1) Open the XML Data File in Excel. Excel can do this.

2) Check the Excel file to see the import is what you want.

3) Save the Excel file as a *.xlsx excel workbook.

4) Open Mathcad Prime

5) Go to menu item Input/Output and you will see READEXCEL as an option use this.

6} A dialog box opens where you can browse for the excel file to read.  It reads it into a Prime matrix.

Cheers

Terry

 

 

T
21-Topaz II
terryhendicott21-Topaz II
21-Topaz II
April 12, 2021

Hi 

You mentioned "date" in your question.

Mathcad Prime has no date value.

Here are some useful date functions.  It explains the difference between Excel and Georgian day number.

Cheers

Terry

T
21-Topaz II
terryhendicott21-Topaz II
21-Topaz II
April 12, 2021

Hi,

Prime 6.0 file if needed.

Cheers

Terry

Terms & ConditionsAccessibility statement