Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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