Question

How to Read multiple sheets data in excel

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.

You can use this utility plugin to read excel sheets.

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.

Sign up