当前位置:软件学习 > Excel >>

Sap Exporting Excel exceed 65535 rows(sap导出Excel超出65535行问题)

SAP在导出EXCEL的过程中最大只能导出65535行,这是因为2003版本的EXCEL只能支持65535导致的,但是现在2007之后的版本
最高可以支持1048576行,打上note1429136就可以满足你的需求了。
Summary
Symptom
Excel 2007 or higher releases supports 1048576 rows, but with XXL_FULL_API only 65536 rows can be exported to Excel.
Other terms
XXL_FULL_API, Office 2007, Office 2010, 1048576, 65536, Rows.
Reason and Prerequisites
Previously with XXL_FULL_API only 65536 rows are supported. Since, in Office 2007 Excel or higher version supports 10,48,576 rows, with this note we extend limit for XXL Export.

Important Note:
1) Even though Excel 2007 or higher version supports 16,384 columns but XXL_FULL_API supports only 256 columns.
2) With XXL Export upto 10,48,576 rows can be exported to Excel, if only when Excel 2007 or higher version is installed. www.zzzyk.com
3) For Excel 2003 and all lower releases of MS Excel, Lotus 1-2-3 note 700206 is applicable.
Solution
Apply relevant correction instruction.

补充:综合编程 , 其他综合 ,
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,