topic Excel Export in QlikView

Excel Export

vijetas42 — Tue, 28 Apr 2015 14:09:16 GMT

Hi All,

I am having one issue regarding excel export your suggestions will be helpful.

My issue is, When I export straight table into excel then it's not showing formatting colors same as straight table and not even header labels from the grid.

it's just showing excel like, please look at attached image for reference. I am having 4,32,065 no. of record in table will it be making any issue. Please let me know.

Thanks!

Re: Excel Export

quwok — Tue, 28 Apr 2015 14:25:55 GMT

Excel files have a 65536 row limit. If you attempt to export more rows than that, QlikView will instead export it as a standard csv file, which has no formatting.

Re: Excel Export

vijetas42 — Wed, 29 Apr 2015 04:28:38 GMT

Hi Kwok,

Same thing i noticed that when I take export instead of send to excel option then it gives me 65536 records in each sheet and also keeps same formatting as straight table.

but, on access point we don't have option as export in that case what should be done please suggest any other option

Thanks!