topic Qlik Table individual cell formatting information missing in Integration, Extension & APIs

Qlik Table individual cell formatting information missing

fmadimba — Thu, 29 Feb 2024 19:31:17 GMT

Hello,

I am developing an extension in JavaScript that will export a qlik table as an excel file or pdf file, and it will add additional information in header/footer of the exported file. Now I want to keep the table formatting in the exported document. The issue I am having is that some of tables have cells that have their own formatting such as background color and text color but qlik does not provide formatting information for each cell. in the qlik dataPage.qMatrix I don't see any information about those formatting. I was expecting it to be in the same block as the qText but it's not there.
Does anyone have an idea on how to accomplish this.

Regards,

Fiston

Re: Qlik Table individual cell formatting information missing

alex_colombo — Fri, 01 Mar 2024 13:17:51 GMT

Hey @fmadimba , the information for cell color is in your hypercube data, under qAttrExps --> qValues. You could have the background color or text color. Below an example of a table with background with red and text color with white (first entry is background, second is text color)

"qAttrExps": { "qValues": [ { "qText": "RGB(128,0,0)", "qNum": 4286578688 }, { "qText": "RGB(255,255,255)", "qNum": 4294967295 } ] }

Re: Qlik Table individual cell formatting information missing

fmadimba — Fri, 01 Mar 2024 16:08:31 GMT

Thanks @alex_colombo I missed that. There is even a html code in element 6 , which has more formatting data.

I appreciate your help.