How to export data to XLSX with maximal rows - 65535 for MS Excel 2003

Owned by martinajindrova
Last updated: Aug 15, 2015
1 min read

Parameters of the method CopyToXLSX() are the same such in Data export to XLSX and ODS.

SET PROCEDURE TO xfrx.fxp
m.loXLSX=CREATEOBJECT("_TOXLSX")
m.loXLSX.nMaxRow=65535 && 1048576, 65535
liErr=m.loXLSX.CopyToXLSX(m.lcAlias, m.lcFile, m.lcFCCallBack, m.lcSheetName, ;
                          m.llAddHeader, m.llShowGrid, m.loProgress, m.lcSheetExpressionGroup)