Excel2CSVHandler

Description

This ActionHandler transforms an Excel(.xlsx) document into one or more CSV documents, depending on the number of sheets in the Excel document. The Excel document has to be attached to the process-instance and the generated files will also be attached to it. If the Excel document contains only one sheet, the generated document will inherit its name, otherwise, each CSV document will be named like the sheet it represents.

Class

com.dooris.bpm.actionhandler.Excel2CSVHandler

Parameter

Description

Valid examples

fileName

This parameter is used to set the name of the document, including the (.xlsx)-doctype.

example.xlsx

csvPrefix

This parameter is used to set a prefix, which will be merged with the beginning of the csv-document's name. Process-variables can also be used.
E.g.:

${SYS.PROCESSINSTANCE_ID}
${SYS.NODE_ID}

prefix_

csvSuffix

This parameter is used to set a suffix, which will be merged with the end of the csv-document's name. Process-variables can also be used.
E.g.:

${SYS.PROCESSINSTANCE_ID}
${SYS.NODE_ID}

_suffix

Example:

We have a simple use case for this actionhandler. We have implemented the excel2CSVhandler on the task exceltoCSV as follows:

Parameter	Valid examples
`fileName`	`example.xlsx`
`csvPrefix`	`prefix_`
`csvSuffix`	`_suffix`

When we open the process instance, we will upload the Excel document via the Documents section.

We will upload the Excel file via the Upload file(s) button.

You can see that the Excel document is now reachable through the process instance.

The actionhandler will be executed once the process instance is started. You can see that, the Excel file which has two sheets now converted to two csv files.

You can reach the original file and the created files under the Documents section.