Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I'm trying to export the pivot table from Qlikview same format table headers are not coming in Excel after send to excel.
please any one help me get this.
My hunch as to why the 'Export' does what it does would be due to the BIFF translator component that does the export, this is a Microsoft module, and I suspect it is not quite sure how to handle things in this case. I am not sure which version you are running either, but if something pre 12.20, know that in 12.20, we have updated the BIFF module we use to allow .xlsx now, and that might result in a different outcome as well, but not certain. Claudiu's solution seems to potentially be a good option, hopefully that will work as a workaround on this one.
Regards,
Brett