How to read data from excel and in which format we can save that data in Appian?

Question

Need to read the data from the excel and save it into an variable

Stefan Helzle · Accepted Answer

There is a smart service to load data into DB. I recommend a two-step approach with a staging table with text fields only. Then write a stored procedure to transform the data into the final table.

Naresh · Answer

Hi, 
 As Stefan mentioned save the data from excel to database if you are planning to store all the data from Excel. In case if your requirement is to read a particular row in Excel file and don't want to save all the data you can use readexcelsheet() function which is available in excel tools plugin. 
 Keep in mind if you use this function readexcelsheet() to read large amount of data it will impact on your application performance. So, I would recommend to load the data to DB directly instead of reading the file.

Mike Schmitt · Answer

Also, Excel Tools has a function to read Excel data straight into local data where it could be parsed and dealt with without needing to just dump it straight into the DB first. " readExcelSheetPaging() " (formerly " readExcelSheet() ").

How to read data from excel and in which format we can save that data in Appian?

Top Replies