Excel2CSVHandler

This action handler 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 it's name, otherwhise each csv-document will be named like the sheet it represents.

Klasse

com.dooris.bpm.actionhandler.Excel2CSVHandler

Event Type

any type

Action Name

any name

Mandatory Fields

-

Parameter

FileName

'fileName' defines the name of the excel-document including the (.xlsx)-doctype.(like in the Example)

csvPrefix

'csvPrefix' defines a prefix, wich will be merged with the beginning of the csv-document's name. Process-variables can be used too. (like in the Example)
E.g.:

${SYS.PROCESSINSTANCE_ID}

${SYS.NODE_ID}

csvSuffix

'csvSuffix' defines a suffix, wich will be merged with the end of the csv-document's name. Process-variables can be used too. like in the Example)
E.g.:

${SYS.PROCESSINSTANCE_ID}

${SYS.NODE_ID}

Beispiel