Connections for INFACore

Back Next

Microsoft Excel

Create a Microsoft Excel connection to read from Microsoft Excel.

Operation	Support
Read	Yes
Write	No

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. You must add the .xlsx extension to the file name.

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.