XLSX to XML conversion in the right format

1

Hi all,

I am currently working on a project where I need to import data from an XLSX file and then export it to an XML file with a specific structure in EasyMorph.

I have an XLSX import file and I would like to create an XML export file that matches the structure shown in the output file.
Input file.xlsx (7.9 KB)
Output file.xml (18.5 KB)

Could you help me with creating an XSLT stylesheet, or do you have any tips to make this process more efficient?

Thank you in advance for your assistance, and I look forward to your response.

2

Hi Tesy,

In your case, XSLT is not required as the needed XML structure is simple. You can generate it simply by text concatenation.

Here is a ready-to-use example:
table-to-xml.morph (13.3 KB)

image
image1673×823 209 KB

3

Thank you for the very quick response! This has been extremely helpful to me.
Would it be possible to save this not as a txt file, but as an xml file?
Thank you very much in advance for your help!

4

Why the question? The workflow I provided exports the result as an XML file. The "Export as plain text action" creates a file with whatever extension you specify.

5

During the last action, I inadvertently saved the document as a (*.txt) file, but thanks to the adjustment, I was able to save it as an .xml file.
Thank you very much for your assistance!

6

You're welcome :slight_smile: