Discussion Board for collaboration related to QlikView App Development.
Hello
When I export to excel the number of columns is limited to column IV. Is there a limit to the number of columns you can send to excel? Is there a setting that you can change in QV to extend the number of columns to export?
We are using excel 2010
Kind regards
Paul
Paul:
At present, Qlikview supports the general parameters that Office 2003 (32-bit) has for eXcel - 256 columns and ~64K rows. If you need something bigger, then use a .csv formatted export (though you will likely need a newer version of 64-bit office to load it if that is the case).
Yes, an excel sheet can have only a limited number of columns. Export to csv if you have more columns then the .xls format supports.
Paul:
At present, Qlikview supports the general parameters that Office 2003 (32-bit) has for eXcel - 256 columns and ~64K rows. If you need something bigger, then use a .csv formatted export (though you will likely need a newer version of 64-bit office to load it if that is the case).
Hi,
Or you can right-click on your table in QlikView, "Copy to clipboard" - "Full table".
Then open Excel and paste.
You will display all your columns.
Regards,
Ludivine