Forum Discussion
jeffrey_crowley
12 years agoContributor
I'm not sure but try this:
var driver = DDT.ExcelDriver("TestData//test.xlsx","Input-Output");
---instead of---
var driver = DDT.ExcelDriver("TestData//test.xlsx","Input-Output",true);
When omitted, the UseACEDriver parameter is false by default. It will use a different driver to open the file. To read more about it, open your code, click on .ExcelDriver, and hit F1.
You have a lot of extra ActiveXObject creation, etc. that you shouldn't need. The driver will take care of all that for you. All you need to do is use DDT.ExcelDriver() to specify the file and sheet, Driver.Value(n) to get the value from the n column, and DDT.CurrentDriver.Next() to go to the next row. See the code example at the bottom of the .ExcelDriver page for a simple example.
var driver = DDT.ExcelDriver("TestData//test.xlsx","Input-Output");
---instead of---
var driver = DDT.ExcelDriver("TestData//test.xlsx","Input-Output",true);
When omitted, the UseACEDriver parameter is false by default. It will use a different driver to open the file. To read more about it, open your code, click on .ExcelDriver, and hit F1.
You have a lot of extra ActiveXObject creation, etc. that you shouldn't need. The driver will take care of all that for you. All you need to do is use DDT.ExcelDriver() to specify the file and sheet, Driver.Value(n) to get the value from the n column, and DDT.CurrentDriver.Next() to go to the next row. See the code example at the bottom of the .ExcelDriver page for a simple example.
Related Content
- 9 years ago
- 5 years ago
- 9 years ago
- 24 days ago
Recent Discussions
- 2 hours ago