Hi All,
we have requirement as mentioned below:
We have excel file which contains multiple sheets and each sheet having multiple rows of data.
we have to read each row from the sheet and pass the input to external system.
external system will send back response to appian where it create case.
please let me know how to read data one after another from each sheet.
can we directly read from excel.
Please share the inputs.
Discussion posts and replies are publicly visible
You can use this utility plugin to read excel sheets.
https://community.appian.com/b/appmarket/posts/excel-utility
thanks Sanchit for sharing the info. but i dont see how to read each row from excel and also from multiple sheets
Did you already try readexcelsheetpaging() function present in the plugin? there you can specify sheet number and pagingInfo for that.
yes, i can see all the rows of data populated. how to read one after another row for 1st three columns.
No need to read data again and again, you can index each row by forming a loop on result and then pass it to external system.