Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
VishrantiC
Contributor
Contributor

CSV generating 65536 rows only from qlikview using Macro

Hi All,

I got one requirement from client to generate CSV file everyday after report refresh and put it on some shared path.

I wrote Macro code for that but after refreshing the file, it is generating 65536 records only in one sheet and moving other records to other sheet of same CSV file. Can anyone help me to handle this?

I need help as soon as possible.

Labels (3)
1 Reply
Miguel_Angel_Baeyens

Office has a limitation on the number of rows that can be exported to Excel on 65k, that limit raised to 1M with the newer versions.

If the code in the macro is leveraging those drivers, updating them should fix it. See for example for more reference: https://www.microsoft.com/en-us/download/details.aspx?id=13255