Skip to main content
anad0004
anad0004
April 4, 2022
Question

Import excel

  • April 4, 2022
  • 8 replies
  • 1 view

Hello,

I am new in appian and  I need to import a excel and save in local variable, after that I need to validate the content of the file (number of columns, etc),  I don't how to start.

Could recommend me the function to do it,  

Could you help me , please?

Best regards,

8 replies

mathieud0001
mathieud0001
Brainy
April 4, 2022

This plugin can help - https://community.appian.com/b/appmarket/posts/excel-tools

There are 3 expressions which you can use:

  • Read Excel File Paged
  • Read Excel Cell by Name
  • Read Excel Cell by Number

There is no way to do directly within the interface this AFAIK since you only have access to the file contents after the form has been submitted.

gopalk2865
gopalk2865
Participating Frequently
April 4, 2022

Hi anad0004, Create a process where user can upload the excel file, once file is uploaded , get the doc id of excel file. Now you would need to write an expression rule with the help of the functions(

readexcelsheetpaging()
excelreadcellsbyname()
excelreadcellsbynumber()

) which Mathieu has already mentioned from excel tool plugin. you can pass the excel doc id into these functions and based on your requirement you can validate the data. I hope it helps.

anad0004
anad0004Author
April 4, 2022

Thanks a lot

anad0004
anad0004Author
April 6, 2022

[mention:5f79d9148514449c9b65c63e87a08830:e9ed411860ed4f2ba0265705b8793d05] Do you have an example about this functions,  there is not much information on the web about this and I am not sure how to implement it.

Could you help me, please?

BR

Terms & ConditionsAccessibility statement