Excel Data Source

You can create an Excel data source from an existing Excel file.

Properties of the Excel data source:

File UNC Path

The file location. This must be a relative UNC since it can be accessed from multiple File Access Manager servers

Example: \\file-server\share1\file.xlsx

Domain

The domain of the user that has access to the file

User / Password

The user that has access to the file

Worksheet

The name of the worksheet in the Excel file to query

Example: Sheet1

Custom Columns Letters

The columns to query, comma delimited

Example: A,B,E,Z.

Enter a column letter, then click + for each additional column

First Row

The first row number to query

First-row columns are headers

Click to read the headers from the Excel sheet