topic Re: Excel formatting while exporting chart data to excel in QlikView

Excel formatting while exporting chart data to excel

vijetas42 — Mon, 20 Apr 2015 13:47:41 GMT

Hi All,

Can I format excel sheet which is exported from any of the chart.please convey your suggestions for the same.

Thanks

ali_hijazi — Mon, 20 Apr 2015 13:49:59 GMT

you can export what you see in QlikView

format your pivot table for example and all formatting will be taken to excel (background colors, font colors,etc...)

vijetas42 — Mon, 20 Apr 2015 13:57:49 GMT

Hi,

if I have a pie chart which is having option send to excel which gives me export like,below image, if I want to change the header color can I do so,

please convey your suggestions on the same.

Thanks!

vijetas42 — Mon, 20 Apr 2015 13:59:15 GMT

I want export of charts like Pie,Line and Bar charts.in form of formatted excel.

Bill_Britt — Mon, 20 Apr 2015 14:01:26 GMT

Hi,

This is not possible. The exports are in BIFF format.

Bill

vijetas42 — Mon, 20 Apr 2015 14:06:13 GMT

Hi Bill,

Thanks for your reply. Is there any way to achieve this.

Thanks!

Bill_Britt — Mon, 20 Apr 2015 14:36:40 GMT

HI,

Not that I know of.

Bill

Anonymous — Mon, 20 Apr 2015 14:37:30 GMT

You can use a macro to export data to excel and to format it there. But macro like this requires system access and can't work on Access Point.