Save excel as xml data

Like (0) Share

Report

Posted on 21 Dec 2021 07:10:30 by bogdanf

Hello!

I'm trying to save a excel sheet as a XML data document with "Save excel" activity.

If "XML data" is selected it requires a XML map input - question: what type of data needs to be the input for this item?

As far as I know XML map is a .xsd document.

The above steps is my work around for bulk import excel data into SQL.

Any suggestions are welcome.

Thanks!

All responses (5)

Answers (0)

MichaelAnnis 5,721 Super User 2025 Season 1 on 22 Dec 2021 at 20:58:16

Like (0)

Report

Re: Save excel as xml data

I have never created an XML Map. You will have to read this documentation:

https://www.brainbell.com/excel/xml-export.html

Best of luck!
bogdanf 16 on 22 Dec 2021 at 17:37:53

Like (0)

Report

Re: Save excel as xml data

of course, it's a nice work around - but is my second choice.
as I replied to @MichaelAnnis, my question remains about the nature of XML map: argument in Save Excel activity when Document format: XML Data.

Thanks!
bogdanf 16 on 22 Dec 2021 at 17:35:24

Like (0)

Report

Re: Save excel as xml data

yeah, you can also choose XML Data
my questions remains: what type of value / argument XML maps accepts for Save Excel activity? is it a string containing .xsd file?

Many thanks!
MichaelAnnis 5,721 Super User 2025 Season 1 on 21 Dec 2021 at 14:22:04

Like (2)

Report

Re: Save excel as xml data

So, I can get it to save as test.xml using the 'Save Excel As' action:

But I don't even know if that is importable to anything.

I found an article that addresses your topic; there may be more work to do:
https://www.brainbell.com/excel/xml-export.html

Best of luck!
Karlis 23 on 21 Dec 2021 at 13:40:48

Like (1)

Report

Re: Save excel as xml data

Hi Bogdanf

I do not think there is an option to save an excel file directly as XML because you have to have a very specific format structure.
It is possible to set up a text variable and then keep appending lines to it in the format you would like your .xml files to be and then use the action to save this text variable as an XML document (a .xml extension is normally used - .xsd is a certain schema of an .xml document).

I do not fully understand what your excel input looks like and what output you wish to achieve but I would read the data from the excel document and set the variables in a specific text format that fits with .xml requirements.