Connections for INFACore > Connections to source and target endpoints > Microsoft Excel
  

Microsoft Excel

Create a Microsoft Excel connection to read from Microsoft Excel.

Feature snapshot

Operation
Support
Read
Yes
Write
No

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.
Folder URI
The directory that contains the Microsoft Excel file. The Microsoft Excel file must be located on the same machine on which the Secure Agent runs.
TreatFirstRowAsHeader
Specifies whether the first row in the file is a header row.
Filename
The name of the Microsoft Excel file.
Note: You must add the .xlsx extension to the file name.

Read properties

The following table describes the advanced source properties that you can configure in the Python code to read from Microsoft Excel:
Property
Description
Row Limit
The maximum number of rows the agent processes.
Default is 0.
The default value indicates that there is no row limit, and the agent processes all records.