iGrafx Automation Wiki

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.

com.dooris.bpm.actionhandler.Excel2CSVHandler

any type

any name

-

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

'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' 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}