Many tables are used in my project cxGrid, general export data use:

 
ExportGridToExcel (dm) dlgOpen) FileName, cxgLIST, True, True, True, 'XLS);//cxgLIST: cxGrid 

This is no problem, is the XLS format EXCEL2003 export file, open the normal, but the amount of data is very big, lines such as tens of thousands or even tens of, with 2003 format is not appropriate, with 2007 format,
A ExportGridToXLSX cxGrid export function, can be exported 2007 format, the code is the same format:

 
ExportGridToXLSX (dm) dlgOpen) FileName, cxgLIST, True, True, True, 'XLSX); 

XLSX export file, however, tend to use Excel when they open an error:

Click "yes" to repair, after the open content is missing a lot:

Want to ask you, the problem how to solve?

CodePudding user response:

What version of the,

CodePudding user response:

You can try other output format

CodePudding user response:

http://blog.sina.com.cn/s/blog_a2591ef70102xlmc.html you look at this

CodePudding user response:

Use version higher cxGrid, a try,