topic loading huge data to excel file in QlikView https://community.qlik.com/t5/QlikView/loading-huge-data-to-excel-file/m-p/391940#M1157954 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i have a huge data around 1lacs rows with 200 columns to be add and displayed in qlikview and also need to export that to excel. can anyone help me to get this done..</P><P></P><P>Regard,</P><P>Grace Rashmi</P></BODY></HTML> Thu, 03 Jan 2013 17:26:16 GMT 2013-01-03T17:26:16Z loading huge data to excel file https://community.qlik.com/t5/QlikView/loading-huge-data-to-excel-file/m-p/391940#M1157954 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i have a huge data around 1lacs rows with 200 columns to be add and displayed in qlikview and also need to export that to excel. can anyone help me to get this done..</P><P></P><P>Regard,</P><P>Grace Rashmi</P></BODY></HTML> Thu, 03 Jan 2013 17:26:16 GMT https://community.qlik.com/t5/QlikView/loading-huge-data-to-excel-file/m-p/391940#M1157954 2013-01-03T17:26:16Z Re: loading huge data to excel file https://community.qlik.com/t5/QlikView/loading-huge-data-to-excel-file/m-p/391941#M1157955 <HTML><HEAD></HEAD><BODY><P>i am trying load the raw data in straight table. since the data is huge im getting as error as 'object out of memory' and not loading to exporting to excel also...</P></BODY></HTML> Thu, 03 Jan 2013 17:59:51 GMT https://community.qlik.com/t5/QlikView/loading-huge-data-to-excel-file/m-p/391941#M1157955 2013-01-03T17:59:51Z Re: loading huge data to excel file https://community.qlik.com/t5/QlikView/loading-huge-data-to-excel-file/m-p/391942#M1157956 <HTML><HEAD></HEAD><BODY><P>The only way to deal with that is add more ram to your machine. Or don't load that data in a straight table. If the only reason is to be able to export that data then try doing that in the script with the STORE statement and export the table to a csv file.</P></BODY></HTML> Thu, 03 Jan 2013 18:17:32 GMT https://community.qlik.com/t5/QlikView/loading-huge-data-to-excel-file/m-p/391942#M1157956 Gysbert_Wassenaar 2013-01-03T18:17:32Z Re: loading huge data to excel file https://community.qlik.com/t5/QlikView/loading-huge-data-to-excel-file/m-p/391943#M1157957 <HTML><HEAD></HEAD><BODY><P>I tried.. Data is huge it is giving error.. plz help me</P><P></P><P>Error- "Excel cannot complete this task with avaialble resources. Choose less data or close other applications."</P></BODY></HTML> Fri, 04 Jan 2013 07:30:37 GMT https://community.qlik.com/t5/QlikView/loading-huge-data-to-excel-file/m-p/391943#M1157957 2013-01-04T07:30:37Z Re: loading huge data to excel file https://community.qlik.com/t5/QlikView/loading-huge-data-to-excel-file/m-p/391944#M1157958 <HTML><HEAD></HEAD><BODY><P>Hey try to export in XLSX format it works.</P></BODY></HTML> Fri, 04 Jan 2013 07:57:43 GMT https://community.qlik.com/t5/QlikView/loading-huge-data-to-excel-file/m-p/391944#M1157958 2013-01-04T07:57:43Z Re: loading huge data to excel file https://community.qlik.com/t5/QlikView/loading-huge-data-to-excel-file/m-p/391945#M1157959 <HTML><HEAD></HEAD><BODY><P>As per excel it cant export that much of data.</P></BODY></HTML> Fri, 04 Jan 2013 09:02:10 GMT https://community.qlik.com/t5/QlikView/loading-huge-data-to-excel-file/m-p/391945#M1157959 khadeer 2013-01-04T09:02:10Z Re: loading huge data to excel file https://community.qlik.com/t5/QlikView/loading-huge-data-to-excel-file/m-p/391946#M1157960 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>This has absolutely nothing to do with QlikView. The issue is with your computer, I think.</P></BODY></HTML> Fri, 04 Jan 2013 11:18:44 GMT https://community.qlik.com/t5/QlikView/loading-huge-data-to-excel-file/m-p/391946#M1157960 Gabriel 2013-01-04T11:18:44Z