Export to Excel

[priyarane]

Hi Experts,

How many columns and rows can be exported from QV to Excel.

In my scenario, I have >300 columns in Table box and users are reporting that not able to see all the columns and many issues.

If any limitations in QV then how can we over come that issue?

Thank you,

Priya

[#2]

Check this Limit to the number of rows that a user can export to excel

Mohssine AMHACHI

[stigchel · Accepted solution]

The number of rows and columns qv can export mainly depends on the excel version you are using. In older excel versions the nr of columns is limited to 256. You can maybe use a csv export instead?

Also see

Re: Limitation of data to download as excel

[praveenak]

Hi,

I don't think there is a limitation on the no.of rows/columns to be exported to excel.

Any no.of rows/columns can be exported. But the no.of columns visible is only based on the excel version you use(like excel 2003 is limited to 256 columns).

In your case, the problem may be due to any aggregations on the fields,in the script. Please verify that.

Or if you can provide the QVW file, we can find the problem.

[priyarane]

Users are exporting from Table box