====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 ==== {{software:tim:actionhandler:example_par_1.jpg}} {{software:tim:actionhandler:example_par_2.jpg}} {{software:tim:actionhandler:example_par_3.jpg}} ----