Connections > Microsoft Excel connection properties
  

Microsoft Excel connection properties

When you set up a Microsoft Excel connection, you must configure the connection properties.
The following table describes the Microsoft Excel connection properties:
Connection property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
Description
Description of the connection. Maximum length is 4000 characters.
Type
Microsoft Excel
Runtime Environment
The name of the runtime environment where you want to run the tasks.
Select a Secure Agent.
Folder URI
The directory that contains the Microsoft Excel files that you want to read.
The directory must be located on the Secure Agent machine.
Treat First Row As Header
Specifies whether the first row of the file should be treated as a header row.
Select true or false.
Folder Access
Reads multiple Microsoft Excel files from the directory specified in the Folder URI property.
By default, the checkbox is not selected.
Filename
The name of the Microsoft Excel file that you want to read.
To read multiple files, specify the name of at least one of the files from the directory specified in the Folder URI property.
The file name must have the .xlsx extension.