Posted 24 April 2020, 1:03 am ESTHello,
When importing a XLSX file with OpenExcel2007File function, cells defined with a quote prefix (') are not imported.
The attached zip file is a C++/MFC (VC6) example to compare importing file with the same content (XLSX and XLS files).
The result is :
- No data in column 11 when reading test.xlsx file
- Data are available in column 11 when reading test.xls file