Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
fmadimba
Contributor II
Contributor II

Qlik Table individual cell formatting information missing

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.

qlikRequestCapture.PNGqlikRequestCapture2.PNG

Regards,

Fiston

Labels (1)
1 Solution

Accepted Solutions
alex_colombo
Employee
Employee

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

View solution in original post

2 Replies
alex_colombo
Employee
Employee

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
Contributor II
Contributor II
Author

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

I appreciate your help.