topic Re: QlikView Export To Excel Issues.. in QlikView

QlikView Export To Excel Issues..

vijayit43 — Fri, 12 Dec 2014 06:41:27 GMT

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

Re: QlikView Export To Excel Issues..

tresB — Fri, 12 Dec 2014 06:51:54 GMT

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.

Re: QlikView Export To Excel Issues..

vijayit43 — Fri, 12 Dec 2014 07:21:35 GMT

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

Re: QlikView Export To Excel Issues..

PrashantSangle — Fri, 12 Dec 2014 07:31:03 GMT

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

Re: QlikView Export To Excel Issues..

vijayit43 — Fri, 12 Dec 2014 08:01:28 GMT

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

Re: QlikView Export To Excel Issues..

vijayit43 — Fri, 12 Dec 2014 08:07:21 GMT

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

Re: QlikView Export To Excel Issues..

vijayit43 — Fri, 12 Dec 2014 09:40:39 GMT

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

Re: QlikView Export To Excel Issues..

Wed, 22 Jun 2016 15:23:59 GMT

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.