Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
paul_ripley
Contributor III

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 (1)
1 Solution

Accepted Solutions
Not applicable

Re: Export to excel - number of columns limit

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).

View solution in original post

3 Replies
MVP & Luminary
MVP & Luminary

Re: Export to excel - number of columns limit

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
Not applicable

Re: Export to excel - number of columns limit

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).

View solution in original post

Not applicable

Re: Export to excel - number of columns limit

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