topic Re: Export large table to Excel in QlikView https://community.qlik.com/t5/QlikView/Export-large-table-to-Excel/m-p/533106#M1126917 <HTML><HEAD></HEAD><BODY><P>here the macro:</P><P></P><P>sub vCSV</P><P></P><P>'Download Sheet ojbect data to CSV</P><P></P><P>set sObject = ActiveDocument.GetSheetObject("CH321")</P><P>sObject.Export "GDPdU0.csv", ";"</P><P></P><P></P><P></P><P>End Sub</P></BODY></HTML> Sun, 29 Dec 2013 12:13:53 GMT bumin 2013-12-29T12:13:53Z Export large table to Excel https://community.qlik.com/t5/QlikView/Export-large-table-to-Excel/m-p/533104#M1126915 <HTML><HEAD></HEAD><BODY><P>All,</P><P></P><P>Is there a way to export large table boxes ? it is running out of memory, when exporting to Excel or in copying to clipboard.</P><P></P><P>Regards</P></BODY></HTML> Sun, 29 Dec 2013 09:04:55 GMT https://community.qlik.com/t5/QlikView/Export-large-table-to-Excel/m-p/533104#M1126915 2013-12-29T09:04:55Z Re: Export large table to Excel https://community.qlik.com/t5/QlikView/Export-large-table-to-Excel/m-p/533105#M1126916 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you can write a macro to export it as CSV. I have exported even big data with this method</P><P></P><P>regards</P><P>Bumin</P></BODY></HTML> Sun, 29 Dec 2013 12:12:07 GMT https://community.qlik.com/t5/QlikView/Export-large-table-to-Excel/m-p/533105#M1126916 bumin 2013-12-29T12:12:07Z Re: Export large table to Excel https://community.qlik.com/t5/QlikView/Export-large-table-to-Excel/m-p/533106#M1126917 <HTML><HEAD></HEAD><BODY><P>here the macro:</P><P></P><P>sub vCSV</P><P></P><P>'Download Sheet ojbect data to CSV</P><P></P><P>set sObject = ActiveDocument.GetSheetObject("CH321")</P><P>sObject.Export "GDPdU0.csv", ";"</P><P></P><P></P><P></P><P>End Sub</P></BODY></HTML> Sun, 29 Dec 2013 12:13:53 GMT https://community.qlik.com/t5/QlikView/Export-large-table-to-Excel/m-p/533106#M1126917 bumin 2013-12-29T12:13:53Z Re: Export large table to Excel https://community.qlik.com/t5/QlikView/Export-large-table-to-Excel/m-p/533107#M1126918 <HTML><HEAD></HEAD><BODY><P>thanks a lot</P><P></P><P>should i type the macro in the Edit Script editor below the other commands ?</P><P></P><P>what if i cannot access the edit script functionality in the QLikView document I wish to export from (limited r/w access) ?</P><P></P><P>thanks</P></BODY></HTML> Sun, 29 Dec 2013 14:31:10 GMT https://community.qlik.com/t5/QlikView/Export-large-table-to-Excel/m-p/533107#M1126918 2013-12-29T14:31:10Z Re: Export large table to Excel https://community.qlik.com/t5/QlikView/Export-large-table-to-Excel/m-p/533108#M1126919 <HTML><HEAD></HEAD><BODY><P>you have to create a button-object</P><P></P><P>find attached an example qvw</P></BODY></HTML> Sun, 29 Dec 2013 16:50:35 GMT https://community.qlik.com/t5/QlikView/Export-large-table-to-Excel/m-p/533108#M1126919 bumin 2013-12-29T16:50:35Z