https://community.qlik.com/t5/QlikView/Will-RowLimitForCsvInsteadOfXls-work-for-XLSX/m-p/1521813#M437589 <P>We recently upgraded from 12.1 to 12.2 and ran into a problem - users were dumping 500k+ rows of data (not ideal, but such is the life of business requirements), which slowed the export down substantially - to the point it was timing out. Before, it would have created a CSV, but now it's trying to create the XLSX (which takes longer).</P><P>If I add in&nbsp;<SPAN>RowLimitForCsvInsteadOfXls=50000, will it work to block XLSX creation for exports over 50k as well?</SPAN></P><P><SPAN>We're looking at increasing&nbsp;the QExportTimeLimitSec to 360 as well, as it seems to generate in 5-6 minutes.</SPAN></P> Mon, 17 Dec 2018 19:14:42 GMT whalenem 2018-12-17T19:14:42Z https://community.qlik.com/t5/QlikView/Will-RowLimitForCsvInsteadOfXls-work-for-XLSX/m-p/1521813#M437589 <P>We recently upgraded from 12.1 to 12.2 and ran into a problem - users were dumping 500k+ rows of data (not ideal, but such is the life of business requirements), which slowed the export down substantially - to the point it was timing out. Before, it would have created a CSV, but now it's trying to create the XLSX (which takes longer).</P><P>If I add in&nbsp;<SPAN>RowLimitForCsvInsteadOfXls=50000, will it work to block XLSX creation for exports over 50k as well?</SPAN></P><P><SPAN>We're looking at increasing&nbsp;the QExportTimeLimitSec to 360 as well, as it seems to generate in 5-6 minutes.</SPAN></P> Mon, 17 Dec 2018 19:14:42 GMT https://community.qlik.com/t5/QlikView/Will-RowLimitForCsvInsteadOfXls-work-for-XLSX/m-p/1521813#M437589 whalenem 2018-12-17T19:14:42Z