Forum Discussion

ian_brown's avatar
ian_brown
Occasional Contributor
12 years ago

Excel Driver Issue

I am getting a 'provider not found' error when running this code :

//------------------------------------------------------------------------------
// Create Jobs based upon a spreadsheet of data
//------------------------------------------------------------------------------
function ExcelJobCreate()
{
Driver = DDT.ExcelDriver("C:/TestComplete Projects/DataFreight/Forwarding Operations/Speadsheets/BasicJob-001.xlsx","sheet1",true);
//Driver = DDT.CSVDriver("C:/TestComplete Projects/DataFreight/Forwarding Operations/Speadsheets/BasicJob-001.csv");
while(!Driver.EOF())
{
CreateBasicJobFromExcel();
Driver.Next();
}
DDT.CloseDriver(DDT.CurrentDriver.Name);

The error occurs on the first line of the function. I have a full copy of Microsoft Office 2013 installed on the same PC. I have successfully used the CSV file driver to drive these tests.

Any input would be welcome...

Thanks,

Ian