ExcelParser Connector
[ | version 3.0]
Connector
The connector is permitted for use of the platform background agent.
Connector processing type: Row by row!
This connector allows to read data from Excel file on first list. It starts reading from first line. In configuration it can be specified if it contains header and also you can select type of processing of columns.
Has header
Check if first line has a header.
Parsed columns
Type of column processing:
- All columns - all columns are taken and mapped to output schema in the same order
- List of column indexes - it can be specified which column take to output by their indexes filled in the following field
- List of column names - it can be specified which column take to output by their header names filled in the following field
List of parsed columns
Comma separated list of header names or indexes. Indexes starts from 1. All selected columns will be mapped in this order to output schema.
Header names
Column1, Column2, Column3, Column4
Indexes
1, 2, 3, 4
Configuration
Excel Parser configuration
Has Header
Check if first line has a header.
Type of Column to process
Type of column processing:
- All columns - all columns are taken and mapped to output schema in the same order
- List of column indexes - it can be specified which column take to output by their indexes filled in the following field
- List of column names - it can be specified which column take to output by their header names filled in the following field
List of Header Names
Comma separated list of header names or indexes.
Excel Sheet configuration
Sheet Name
Sheet name from which data will be read.
Sheet Selector
Select how you want to identify sheet which will be read:
- Name - select sheet by name
- Index - select sheet by index
Sheet Index
Sheet index from which data will be read, starting at 1.
Input & Output Schema
Input
Input is Base64 encoded Excel file which contains data on first list and can have also header for more user friendly mapping.
Data (ver. 1.0.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Data | Base64 | No | Binary data encoded into Base64 string. |
Example input data
Base64 encoded content of Excel file.
Data: Base64 |
|---|
| ewogICAgIlN1Y2Nlc3MiOnRydWUKfQ== |
Output
Output schema is mandatory, but not specified by connector.
Release notes
3.0.4
- Plugin binaries update as a result of included connector change
3.0.3
- Fixed shared nuget package versions.
3.0.2
- Fixed right processing of nullable properties.