Export to excel

[neha_shirsath]

Hello Community,

Please guide me for the below problem.

When I exporting more than 65000 record from .qvw to excel it saves in .csv format.

but in Access point when i exporting same data it gives below data in excel..

<result><message text="Session lost" /><restart/></result>

And also tell me Can we export more than 65000 records in excel in Access point??

or it get save in .csv format?

Thanks in advance.

[Gysbert_Wassenaar]

On the server you can change the limit in the QVS settings.ini file

[Settings 7]

RowLimitForCsvInsteadOfXls=65500

In Qlikview Desktop you can change this with an 'easter egg' setting. In the Help menu select About Qlikview. Then right click on the Qlikview icon in the lower left corner. Find the entry RowLimitForCsvInsteadOfXls. You can then increase the value from 65500 to a higher number. Note, this may cause a performance penalty on your server.

[neha_shirsath]

Thanks Gysbert for your guidance.

but when m exporting record in .qvw it automatically save in .csv

but in Access point that is not happening. .

[#4]

Hi Neha,

Did you get any further with this?

I'm trying to export 100,000+ records with 76-78 columns (using QV 11.2 SR3) when I try using IE (AJAX) I get the above, I've tried extending the timeout in the config file, but no luck!

I can export if I open the document locally on the server and export, but this is not an elegant solution.

Thanks

Gavin

[rajeshvaswani77]

Whats your excel version on access point? The older excel 2003 only 65000 odd rows.

thanks,

Rajesh Vaswani

[#6]

I've shrunk down the number of columns and then the format changes to a .csv (which is fine) however I just think that the connection times out on the server due to size and there has to be a way to change this......

[#7]

I would say, in my testing that large datasets were exported into a .csv (instead of a .xls) this is what I am after rather than a .xls extension.

Any thoughts???

Thanks

[jpapador]

You can also create a button that has an action to export to a .csv file.  This way it wont go through trying to export as .xls

[rajeshvaswani77]

Hi,

Could you please check the end of this post. The server setting that you would have to change.

http://community.qlik.com/message/189096#189096

thanks,

Rajesh Vaswani

[#10]

Hi I have to use AJAX as the client plugin doesn't work (with rendering the reports) therefore I can't use a macro in the button to export to .csv.

I'll review the timeout length was set to 60 originally (changed to 3600) will move it up again and see what happens in the .config file....