Qlik Table individual cell formatting information missing

[fmadimba]

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

[alex_colombo · Accepted solution]

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
		}
	]
}

[fmadimba]

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

I appreciate your help.