Excel Reader

ONEWEB from version 4.0.19.11 supports custom extensions for Process and Microflow. There are some custom extensions provided by ONEWEB along with the platform. One such available extension bundled with ONEWEB is the Excel Reader extension. It can be used to read data from Excel files.

To read data using Excel Reader, the user needs to first install the extension to their application. Please follow the steps as described in section 6.4.16. to install and enable the Excel Reader to your application. Once the extension is installed and enabled, you can use it just like any other node in the diagram palette.

Users can configure the properties for reading the file as shown below. The File Source can be the File System or network, allowing for FTP options like FTP, SFTP & FTPS. Users can enter the source and file details directly or even get the data from the Business Object as shown in the example below.

Users can read data from multiple sheets by mapping the input the data passed to the Reader

The data can be read from a specific column on excel as shown under the specific Field parameter or can read entire rows as configured under the records parameter under each individual sheet.