I´m just starting in Appian and I want to create a process in which I upload an Excel with some registers and for each register the process create a task. Is it possible to do it easily?
Discussion posts and replies are publicly visible
Hello miguelm137538
I assume this is what you are asking? If so You can use readexcelsheetpaging excel tool plugin to read you excel file and extract values as needed. You need to write code to create tasks foreach record/row you have. You need to remove headers from parsed data or format template.
= a!localVariables( local!parsedFileData: index( readexcelsheetpaging( ri!excelDocument, 0, a!pagingInfo(1, cons!SRT_INT_FILE_IMPORT_ROW_MAX), 3, null, true ), "data", "values", {} ), if( rule!APN_isBlank(local!parsedFileData), {}, a!forEach( items: local!parsedFileData, expression: a!map( firstName: stripwith(fv!item[1], " "), lastName: stripwith(fv!item[2], " "), allocation: fv!item[3] ) ) ) )