D7 transit EXCEL2003 is OK, more than 35536 will save a file;

However, now more than 65536 turn EXCEL2007, this is in more than 65536 lines of records will not take out, arguably EXCEL2007 support on the number of rows is more than 100, 1048575,

The question is: if the number of records of more than 65536, EXCEL 65536 lines, the maximum number of records in turn out more than the line would not come out??

Turn the EXCEL code is as follows:
ExcelApp:=CreateOleObject (' Excel. Application);
.
ExcelWorkBook:=ExcelApp. WorkBooks. The Add (FileNam);
ExcelSheet:=ExcelApp workSheets [1].
.
ShowMessage (' data stored in the: + FileNam);
ExcelApp. ActiveWorkbook. SaveAs (FileNam,, ', ' ', False, False);
ExcelApp. WorkBooks. Close;

FileNam for files in the directory, such as c: \ aa XLSX

Please expert help, thank you!!!!!

CodePudding user response:

D7 Excel - OleObject highest version is OfficeXP
XE10 may support an, there is no actual tested

It is said, D7 Excel Server can even open Offic2007 document is in compatible way

In fact, if the Excel document is the data table, it is recommended to use ADO to access Excel document with logic more readable

CodePudding user response:

D7 this to is not solve, try resolved through a third party controls, or by XE,

CodePudding user response:

reference 1st floor doloopcn response:

D7 Excel - OleObject highest version is OfficeXP
XE10 may support an, there is no actual tested

It is said, D7 Excel Server can even open Offic2007 document is in compatible way

In fact, if the Excel document is the data table, it is recommended to use ADO to access Excel document with logic more readable

Reference is flow between me and write, if the loop a pen a pen to write is OK

CodePudding user response:

https://blog.csdn.net/victor_yang/article/details/86570334
I have export excel operation, do not need to consider the excel version, but you should each cell operation, is part of a fast,

CodePudding user response:

Into an version is not recommended, D7 for office2003 can also,

CodePudding user response:

Corresponding office2003 D7 only.

CodePudding user response:

Try the third party controls XLSReadWriteII5