Excel Export

[vijetas42]

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!

[quwok]

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.

[vijetas42]

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!