Excel

Formats

You can connect to Microsoft Excel workbooks in format *.xlsx or *.xls containing “database-like” tabular data.

The Excel workbook should have column names at first row of sheets followed by data rows.

The data type of all values in a column should all be the same. Trying to parse an Excel file where a column has a number as first value and string as second value will result in a parsing error in SQL buffer.

Other complex sheet designs may not be supported.

Formulas are executed every time the file is opened.

*The maximum file size you can use in a connection is 100Mo

Selecting Connection Type

In the “Create Connection” dialog change the Connection “Type” by selecting “Excel” (should be selected by default) :

Connection Parameters

File Path

Click to browse for an Excel file.

!Important :
The path configured here may not be accessible when published in Alpana Server for different reasons (maybe it’s a different machine and the Excel file is not there at the same path, maybe the Windows user doesn’t have access to the path).
When published in Server, the Windows user will be that configured in the IIS site, by default “LocalSystem”, which can correspond to “NT AUTHORITY\SYSTEM”.
When the file is not found at the configured path, Alpana uses the copy of the Excel file that is embarked within the Dashboard. If so, then you will not see your data update.

Connection Schema

The Excel Connection presents Excel Sheets as tables to be used in a Data Source.

Data refresh and Buffer

The Excel Connector is bufferized.

If you need to get new data, see Chapter The data Buffer

Code192 2020 All rights reserved