topic can qlik sense table export data export cell color? in App Development

can qlik sense table export data export cell color?

Fri, 27 Nov 2015 20:22:50 GMT

i've got an app with a table where some of the information is conveyed using cell background color. when using 'export data', the resulting xlsx only has values, no colors. am i missing something? works in qlik view, no?

table in qlik view:

resulting xlsx (no cell color):

Re: can qlik sense table export data export cell color?

robert_mika — Sat, 28 Nov 2015 04:44:43 GMT

No this option is not available.

The option says "Export Data!

In QV similar option says "Export to Excel" - and the colors are being copied to Excel

Re: can qlik sense table export data export cell color?

Sun, 29 Nov 2015 19:14:44 GMT

color can = data. ex, my case. the 'export data' exports into xlsx, which is excel, and supports color cell formating. anyone know if this is something that's planned to be added into QS?

Re: can qlik sense table export data export cell color?

Mon, 30 Nov 2015 02:49:11 GMT

You can do it like this way, open it in your browser such as chrome, then open the develop tool, view the html of the table, then copy the HTML of the table, paste it to notepad, change the file format to HTML, open in browser again, copy the data (CTRL A, CTRL C) paste to Excel , this kind of data will be exported with format and color.

Re: can qlik sense table export data export cell color?

reddy-s — Mon, 30 Nov 2015 13:09:42 GMT

Hi Michal,

As of now this property is not available in Qliksense.

Re: can qlik sense table export data export cell color?

JonnyPoole — Mon, 30 Nov 2015 16:06:21 GMT

Not to excel, but yes to PDF or Image. I think once NPrinting is integrated with Qlik Sense finer control of the excel export can be achieved. Right now its a data dump whereas NPrinting would produce a report which implicity means data + formatting.

Re: can qlik sense table export data export cell color?

fan325hung — Wed, 09 Aug 2017 07:40:43 GMT

Hi Everyone,

Does this option available in new release (i.e. June 2017)?

Re: can qlik sense table export data export cell color?

shloime — Fri, 27 Aug 2021 14:39:53 GMT

You can use the LogiExport extension to achieve this functionality and much more such as adding "selection context" to the file and more.

https://logiexport.logsys.co.il/documentation/