Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paul_ripley
Creator III
Creator 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

1 Solution

Accepted Solutions
Not applicable

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
Gysbert_Wassenaar

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

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

Not applicable

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