With the ExcelFile connection, you can connect to Excel workbooks with XLSX format and to Jedox Web spreadsheets with WSS format.
Settings
| Location | See Locations for File-based Connections. |
| File name | Name of the file in Excel format. The syntax of the filename is location-specific. More info in article Locations for File-based Connections. |
| Password of Excel file | The password for the file.
Note to Excel 2016: to open password-protected Excel 2016 files, the "Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files" have to be installed in the Java Runtime Environment (JRE). These files can be downloaded from http://www.oracle.com/technetwork/java/javase/downloads/jce8-download-2133166.html. The installation must be in directory <JRE_HOME>\lib\security. |
- Formulas are only evaluated for files in the XLSX format, not for files in the WSS format.
- The "Strict OOXML" format is currently not supported.
- The maximum array size required for Excel file processing has the default size of 100 MB (referred to 100,000,000 in array length). If needed, you can increase the corresponding byteArrayMaxOverrideSizeParameter of the component.xml file under <Jedox Path>\tomcat\webapps\etlserver\config\standard\ (e.g.,
<parameter name="byteArrayMaxOverrideSize">150</parameter>. The value of the parameter is measured in megabytes.
Connection to Google sheets:
With the ExcelFile connection, it is possible to connect to Google Sheets, a web-based spreadsheet program that is part of Google Drive. The Google Sheet has to be published to the web in the format "Microsoft Excel (.xlsx)". It is convenient to activate the option "Automatic republish when changes are made".
Note that the published file doesn't carry over sharing permissions, so anyone will be able to access it. Make sure that the used Google account allows this public publishing. In the ExcelFile connection, the URL of the published file must be used with location "HTTP". No password is required. As publishing is done with HTTPS, the SSL mode has to be set to "trust" or "verify".
Using Google sheets allows also the extraction from the web analytics service Google Analytics. Therefore the Google Analytics Spreadsheet Add-on has to be installed in Google analytics. Create a Google Sheet for the data and set a suitable intervall in the Add-on to refresh the data e.g. monthly. The Google Sheet has to be published to the web as described above and can then be used in the ExcelFile connection.
Updated July 21, 2025