Qlik Sense : Export to Excel Option ,Excel file Cell background color are missing

[muniyandi]

Hi Team,

i have developed qvf file with pivot chart and applied cell background color .

export to excel option background color was not applied in that excel file. how to resolve this issue ?

Thanks,

Muniyandi

[muniyandi]

Any suggestion pls

[jasmina_karcic]

Exporting into excel format, you get just data in table, without format that you applied in application.

Unfortunately...

Because of that, I was trying to make NPrinting excel report that I can call by on-demand extension. But, I have problem with certificates, so I couldn't realize that still. I can just make and use it on new stand, or by sending email...

I think Qlik developers should work on this issue

Jasmina

[agigliotti]

Take a look at this extension https://github.com/iviasensio/SmartExport

I think you should achieve it.

[muniyandi]

it's not working . i had used this extension, i got download icon .but while clicking that icon export functionality/Action are not happening.

[balabhaskarqlik]

No this option is not available.

Exporting data in excel doesn't allow to export with color formatting.

The option says "Export Data!

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

May be,

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.

[agigliotti]

did you try on Qlik Sense Desktop or Qlik Sense Server ?

which version are you using ?

[muniyandi]

Qlik sense Desktop version November-2017 Patch 2.

[Vasiliy_Beshentsev]

As far as i know, the only way to use excel with formatting is with NPrinting reports.

[jasmina_karcic]

I think also...