topic Excel header color in export in QlikView

Excel header color in export

Fri, 16 Jan 2015 10:23:32 GMT

Hi all,

do you know how can I change the header color in the excel export done in qlikview?

I just made an export where the header color is dark green that is unreadble since the font color remains black and I don't know how to roll back.

Thanks in advance for your help.

Re: Excel header color in export

Anonymous — Fri, 16 Jan 2015 10:38:50 GMT

that is possible:

- menu "View": select desgin grid

- Position column Header, right mouse click

- select "custom format cell"

- define backgorund Color to your liking

- Export to Excel: Header column will Show in your Background color

Re: Excel header color in export

Fri, 16 Jan 2015 11:51:31 GMT

Thanks a lot. I just want to add this: the transparency settings on the background color in the "custom format cell" do not affect the background color of the excel header... that's why I had light green in qlikview and dark green in Excel.