Save excel as xml data

(0) Share

Report

Posted on 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!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

Karlis 23 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (2)

Report

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!

Was this reply helpful? Yes No
bogdanf 16 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
bogdanf 16 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report

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!

Was this reply helpful? Yes No