topic Re: Export to excel..can format be edited in QlikView

Export to excel..can format be edited

neelamsaroha157 — Wed, 19 Jul 2017 17:51:52 GMT

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

Re: Export to excel..can format be edited

neelamsaroha157 — Wed, 19 Jul 2017 18:14:49 GMT

stalwar1‌ rwunderlich‌ marcus_sommer‌

Re: Export to excel..can format be edited

marcus_sommer — Wed, 19 Jul 2017 20:17:28 GMT

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

Re: Export to excel..can format be edited

neelamsaroha157 — Wed, 19 Jul 2017 20:42:33 GMT

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.

Re: Export to excel..can format be edited

marcus_sommer — Thu, 20 Jul 2017 05:09:16 GMT

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

Re: Export to excel..can format be edited

neelamsaroha157 — Thu, 20 Jul 2017 12:53:29 GMT

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.