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 ?
Exporting into excel format, you get just data in table, without format that you applied in application.
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
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.
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.