Hello,
I'm new to Appian and currently exploring its features.
I'm looking to implement a feature where users can upload Excel files and view the data contained within those files.
Discussion posts and replies are publicly visible
Hello prashantk3550
As Stefan mentioned you can use a second user input task after your upload file UIT and display the data. You don't have to save the information anywhere.you can use the read excel functions and achieve this. Below is a link for the functions Plug-in which would be helpful to achieve your requirement. Excel toolsFile to read
Hello Konduru,
Could you kindly assist me with the process and steps required to accomplish this task?
In the first interface have a file upload component which would collect your file and save in a process variable which would be processed by a expression rule in a script task.
Below would be an example expression to read the excel file that you will call in the script task.
if( a!isNullOrEmpty(ri!document), {}, a!localVariables( local!data: readexcelsheetpaging(ri!document, 0, a!pagingInfo(1, 5000)), local!onlyData: index(local!data, "data", null), local!employeeData: a!forEach( items: local!onlyData, expression: 'recordType!{b874b8c8-2b7c-4682-a353-db38d26b3d5d}RSS Employee Data'( 'recordType!{b874b8c8-2b7c-4682-a353-db38d26b3d5d}RSS Employee Data.fields.{4d31204d-eee7-4358-a239-22528b0970b1}id': index(fv!item.values, 1, null), 'recordType!{b874b8c8-2b7c-4682-a353-db38d26b3d5d}RSS Employee Data.fields.{e3826105-b66e-4f75-b773-ca82c5c47fde}name': index(fv!item.values, 2, null), 'recordType!{b874b8c8-2b7c-4682-a353-db38d26b3d5d}RSS Employee Data.fields.{adf67688-eb07-43a8-9b74-432aada8fb3e}department': index(fv!item.values, 3, null), 'recordType!{b874b8c8-2b7c-4682-a353-db38d26b3d5d}RSS Employee Data.fields.{6314bbfb-73fa-4250-aa5f-7c1bd371ebd2}city': index(fv!item.values, 4, null), 'recordType!{b874b8c8-2b7c-4682-a353-db38d26b3d5d}RSS Employee Data.fields.{d0eca402-2b17-45d8-b350-3382cbfa7466}createdBy': "blahblah.blah@blah.com", 'recordType!{b874b8c8-2b7c-4682-a353-db38d26b3d5d}RSS Employee Data.fields.{fb823c93-7630-49ba-b01c-7fd06a0da64a}createdOn': now() ) ), local!employeeData ) )
Here the indexes would represent your excel columns and using these you can map your data while casting to your data type.
you can store it in the out put and in the next interface use this variable as an input and display