Excel Writer
Last updated
Last updated
Excel Writer extension is another extension provided by ONEWEB along with the platform. It can be used to write data to Excel files.
Similar to the Excel Reader Extension, to write data to Excel Files, 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 Writer 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 writing the file as shown below. The File Destination can be the File System or network, allowing for FTP options like FTP, SFTP & FTPS. Users can enter the directory and file details directly or even get the data from the Business Object as shown in the Excel Reader. There is also an option to transform data to pre-defined formats while writing.
The data can be written to the specific column on excel as shown under the specific Field parameter or can be written as entire rows by configuring under the records parameter. Users can write multiple sheets of data using one Excel Writer.
