search

Synthoid / ExportSheetData

Add-on for Google Sheets that allows sheets to be exported as JSON or XML.
MIT License
236 stars 46 forks source link

(XML) cannot have a cell value with < or > #83

Closed phtsang closed 5 years ago

phtsang commented 5 years ago

Great work! This is the most promising thing for XML outputs!

I have some values inside my cells as < and/or > But the XML output is &lt; and &gt;

If this is fixed then I have a working nested XML for my purposes. By using =CONCATENATE(<child1>,child1,</child1>,<child2>,child2,</child2>) ?

Thanks!

Synthoid commented 5 years ago

By default, illegal XML characters are formatted to use safe encoding. You can disable this by using the Don't format illegal characters option. That should do what you want.