DDT issue about office 2003

环境: TC 7.2; office 2003

Code： Driver = DDT.ExcelDriver("../Test.xls","TestSheet",true);

结果：如图所示

解决方法：

Driver = DDT.ExcelDriver("../Test.xls","TestSheet",false);

原因：

If this parameter is True, TestComplete uses the ACE driver to connect to the specified Excel sheet. If the parameter is False, TestComplete connects to the sheet via the Microsoft Excel ODBC driver.

The ACE driver lets you connect to Excel 2007 sheets as well as to sheets created in earlier version of Microsoft Excel. The ODBC driver does not support Excel 2007.

The ACE driver is part of the 2007 Office System Driver: Data Connectivity Components package that is installed along with Microsoft Office 2007. You can also download this package from Microsoft’s web site (http://www.microsoft.com/downloads/).