| || |
Read Excel (MS Office 2007) in TC v 5
We are using TC v 5
We are using MS office 2007
i wanted to read Excel workbook
When i gave following command
ddtdriver = DDT["ExcelDriver"]("C:\sample\TC_CB_Learn.xlsx", "Sheet1");
I am getting this error message and the execution stops
An exception occurred in the "Unit1" unit at line 24:
Cannot update. Database or object is read-only
Please could any of you help
Re: Read Excel (MS Office 2007) in TC v 5
The issue is that the Microsoft Jet engine used in TestComplete to access Excel sheets does not support the format of Excel 2007 documents (xlsx). We will try to switch to the ACE engine that supports these files in one of the future versions of the tool.
In the meantime, you can save your Excel files as 'Excel 97-2003 Workbook' documents.