Excel Connector
# Excel Connector
You will find Excel connector in TALXIS.Connectors.Excel.zip solution which you can import to your environment. Connector contains two actions:
- Create Excel From Array
- Fill Excel Repeater Template
- Fill Excel Template
# Making connection
There are currently two ways to make connection:
You can use an api key. This one is generated for every customer.
You use the general document connector. That one is authorized with Azure AD login (your email address)
If for some reason you don't have access to neither of them, please contact NETWORG support.
# Create Excel From Array
# Input
Name | Type | Description |
---|---|---|
Property item | json |
# Output
Name | Type | Description |
---|---|---|
Body | Text | Excel document. |
# Fill Excel Repeater Template
This action is used to populate word template with data. For making document template please visit this Excel Repeater Template page
# Input
Name | Type | Description |
---|---|---|
Properties | json | JSON object of data which will populate template. |
Document | Text | Excel file in binary format which will be populated with properties |
# Output
Name | Type | Description |
---|---|---|
Body | Text | Populated excel document. |
# Fill Excel Template
This action is more advance version of previous one. You can read more in Excel Template page
# Input
Name | Type | Description |
---|---|---|
Properties | json | JSON object of data which will populate template. |
Document | Text | Excel file in binary format which will be populated with properties |
# Output
Name | Type | Description |
---|---|---|
Body | Text | Populated excel document. |