Skip to main content
azharuddim218359
azharuddim218359
April 20, 2022
Question

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

  • April 20, 2022
  • 8 replies
  • 0 views

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

8 replies

stefanhelzle0001
stefanhelzle0001
Brainy
April 20, 2022

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.

mikes0011
mikes0011
Brainy
April 20, 2022

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()").

richardm900458
richardm900458
April 20, 2022

I would like to challenge why you try to do this? What is the overall target?

azharuddim218359
azharuddim218359Author
April 21, 2022

Scope is to enter multiple request at a single go.

N
nareshs945
April 20, 2022

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.  

azharuddim218359
azharuddim218359Author
April 21, 2022

What amount of data will effect the application performance? requirement is to read data which will be not more than 100 rows.

Terms & ConditionsAccessibility statement