Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

can qlik sense table export data export cell color?

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:

ss 2015-11-27 at 3.17.33 PM.jpg

resulting xlsx (no cell color):

ss 2015-11-27 at 3.16.50 PM.jpg

6 Replies

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

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

Not applicable

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

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?

Not applicable

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

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.

reddys310
Honored Contributor II

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

Hi Michal,

As of now this property is not available in Qliksense.

Employee
Employee

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

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.

fan325hung
New Contributor II

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

Hi Everyone,

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