Export to excel..can format be edited

[neelamsaroha157]

Hi Community,

I am exporting data to xml but then issue is I do not want the object type to be part of the exported script.

Any idea how I can export without it.

Here is the sample of exported file. I don't want 'encoding="utf-8" and '<TableBox' to be part of my exported file.

Appreciate any help.

Thanks

[neelamsaroha157]

stalwar1‌ rwunderlich‌ marcus_sommer‌

[marcus_sommer]

I don't think that you could customize it from the qlik-side. You will need some external routine maybe with some vbs/vba-code which removed the unwanted parts. Maybe a different export-format for example an excel or csv may be more suitable for you.

- Marcus

[neelamsaroha157]

Thanks marcus_sommer‌ for your input.

Is there a way to write a macro which can copy the content to clipboard, remove the unwanted string and finally export it to XML.

I cannot change the file format as this data submitted to other organizations & it needs to be a xml format.

[marcus_sommer · Accepted solution]

Within the clipboard you couldn't change it but you could change the file within an intermediated step. The second code-part from here: XML export, transform and import does made a similar change by reading the xml just as simply text-file, replacing some parts and writing it back:

But I could imagine that it could be easier to export this object several times into different formattings and/or to adjust the following processes so that the xml-header and the <Tablebox> wouldn't be a problem.

- Marcus

[neelamsaroha157]

Thanks marcus_sommer‌

For now I used Notepad++ to replace the string as temporary solution.

But I'll try the option suggested by you, will give it some hit & try.

Appreciate you help.