Excel File Reader
The Excel File Reader Action Agent is used to read Excel spreadsheet files and output their contents as events.
This can be used with a File Listener to batch-process data from Excel and turn it into actionable data. Simply drag and drop Excel files into a folder monitored by the File Listener, and the Excel File Reader will process them.
It can also be used with an Excel file binary string from another agent, such as an Email Listener processing an email received with an Excel file attachment.
Details for examples and the configuration can be found in the How to Use section.
Pre-requisites
Excel files used with this Agent must be in *.xlsx format.
Current Version
Request the Excel File Reader Action Agent v1.14 (Last Update: 08 Oct 2025)
Please contact XMPro if you're looking for an older version of this Agent.
Release Notes
1.14
08 Oct 2025
Support appending the input payload to the file content. Standardized property names.
1.13
27 Dec 2024
Repackaged to translate the Agent's properties.
1.12
12 Dec 2022
Repackaged the Agent's category from Function to Action Agent.
1.11
29 Apr 2022
Support Base64 binary string.
1.08
30 Mar 2022
Added Pivot Data & Row Limit.
1.07
05 Dec 2019
Fixed grid key errors.
1.06
04 Mar 2019
Updated help url.
1.05
13 Aug 2018
Added error endpoint.
1.04
06 Jul 2018
Fixed file definition upload-related options not reverting if it is no longer desired.
1.03
15 Jun 2018
Fixed incorrect cell address calculation.
1.02
15 Jun 2018
Fields are converted to their desired output type.
Removed empty-string-for-null substitution.
Missing fields are added with null values.
Raw ARGB values are output for unmapped colours.
An empty string is output for white, unless otherwise specified in the map.
1.01
15 Jun 2018
Added option to replace empty cell's null values with empty strings.
Added file definition upload.
1.00
15 Jun 2018
Initial Release.
Last updated
Was this helpful?