

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Export to excel - number of columns limit
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
- Tags:
- excel-export
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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).

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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).

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
