QlikView Export To Excel Issues..

[vijayit43]

In My QV Chart 1 month data is maximum 8 lacs rows and 48 column user when export to excel on Accesspoint then min 8 min showing exporting after that give error in excel is session lost.

My Question is 8 Lacs Rows not exporting at a time ,if not then how many records exports at one time My System Configuration is

If Required we Increase System Configuration..

[tresesco]

It depends on MS Excel version:

It is perhaps like:

Excel 2003 -> it was 65,536 rows

Excel 2010+-> 1,048,576

So upgrade ms office if in the scope.

[vijayit43]

We have using Excel 2013 which system to access QV Chart but give Error on Session Lost after 8 to 10 minute.

[PrashantSangle]

Hi,

I dont think it was excel export issue.

Check your net speed and CPU/RAM utilization of Server machine when you export data.

Regards

[vijayit43]

My System Net Speed is Good and Server cpu utilization at maximum30% and ram utilization 57%.

[vijayit43]

When we calculating data Size in excel its approximately 350mb.

[vijayit43]

Max how many size of data export to excel from AccessPoint.

[#8]

Hi Vijay,

When we export to excel in access point, the excel gets generated in the version of Excel defined in the version of QV you are using. I suspect that the QV version you have uses MS Excel 2003, for which the limit of rows is 65536.

We had checked with QV team on this and they said it is not possible to upgrade the version of Excel used. We may have to upgrade to the latest version of QV where MS 2007 is being used.

As a workaround you can export data in .CSV format to resolve export issue.

Regards,
Shiva

[phaneendra_kunc]

Do you know which version of QV uses MS 2007 or higher?