DDT.ExcelDriver "Unexpected error"
I'm having some difficulty with the DDT.ExcelDriver, and I'm wondering if anyone has run across this before. Essentially my task is to read in some data from app generated Excel files (XLS and XLSX),...
Forum Discussion
I don't think the spaces are causing the issue because all our DDT .xls files have sheets with spaces in the name and we don't see that error message.
We have occasionally had issues with .xls and .xlsx where the sheet becomes corrupt and you can't see why. Try creating an new sheet with some of the data from one of the sheets that doesn't work and see if that will run. Don't copy/paste the data, but type it in manually.
We have occasionally had issues with .xls and .xlsx where the sheet becomes corrupt and you can't see why. Try creating an new sheet with some of the data from one of the sheets that doesn't work and see if that will run. Don't copy/paste the data, but type it in manually.
