ian_brown
12 years agoOccasional Contributor
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
//------------------------------------------------------------------------------
// 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