Using CSpreadSheet reading Excel the following problems:


Can you tell me how to solve?

CodePudding user response:

Connect ODBC to excel method call if there's any problem

CodePudding user response:

There was a problem is in the call ODBC, upgrade system vulnerabilities today, after the success of the upgrade, cannot be read correctly

CodePudding user response:

When using the connection string to connect to Excel, can replace the JET with ACE
Will: "the Provider=Microsoft. Jet. The OLEDB. 4.0; The Data Source=mySpreadsheet. XLS; Extended Properties='Excel 8.0; HDR='";
Correction: "the Provider=Microsoft. ACE. The OLEDB. 12.0; The Data Source=mySpreadsheet. XLS; Extended Properties='Excel 8.0; ';"

Patch KB4041678 or uninstall