ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: CharlestonGeek on October 01, 2020, 11:53:23 am

Title: Export Header Cell Styling
Post by: CharlestonGeek on October 01, 2020, 11:53:23 am

Working with version 7.5.0...
How can I export to excel the 'background-color' set in styleHead on the colModel?

Code: [Select]

...
{ title: "Source", dataIndx: "Source", styleHead: { 'background-color': '#ffffff' } },
{ title: "Source", dataIndx: "Source", styleHead: { 'background-color':'#007cb0' } },
...
however they export into excel with grey background color (bgColor).
Thank you for your assistance.

Title: Re: Export Header Cell Styling
Post by: paramvir on October 01, 2020, 12:46:04 pm

There is no inbuilt support for export of header styles currently, might be added in upcoming versions.

However you can add styles to header cells by creating js workbook and add styles to header rows or cells manually before export it to Excel.