If you try accessing the DDT.ExcelDriver
method from your scripts without having MS Office installed, you will get the error Provider cannot be found. It may not be properly installed.
In this recipe we will learn how to avoid this problem without installing MS Office.
In order to have access to Excel files via DDT perform the following steps:
DDT
data from scripts.Data Connectivity Components is a part of MS Office system, but it can be also installed separately to have access to xlsx
files (files created in MS Excel 2007 or higher).
If you also need to edit Excel files on this computer, you can use the LibreOffice suite (http://www.libreoffice.org/) which is free.
18.117.93.0