Poland

Welcome to the Poland User Group

Click in the JOIN GROUP button in Home to follow our news and attend our events!

SOLVED

Excel to XML, with leading indents (tabs)

Szymon_Czuszek
8 - Asteroid

Hello all,

 

I have a project to create, which lets me save the file from Excel to XML. I managed to successfully create a desired result, but the indents are only saved, when I copy the result from the browse tool actions. When trying to export the file in csv, xlsx or other, using the standard output tool, the indents are cleaned. Is there a way to save the indents, without using the browse tool copy to clipboard option?

 

Kind Regards,

Szymon

4 REPLIES 4
Emil_Kos
17 - Castor
17 - Castor

Hi @Szymon_Czuszek,

I am not sure what the problem is. Please ping me on LinkedIn if you still need any help: https://www.linkedin.com/in/kosemil/


Szymon_Czuszek
8 - Asteroid

Hi, actually I resolved this by adding a Python module, and saving the output directly from the Python tool with the write method. Thank you for reaching out though :)

Szymon_Czuszek
8 - Asteroid

Another way to output as xml, is choosing csv as file format in regular output data tool, and setting the delimiters as: \0

Szymon_Czuszek_0-1680678601251.png

 

smugabart
8 - Asteroid
8 - Asteroid

Thanks for sharing that!