Hi All,
I have immediate requirement in my project where we need to read Excel files in Appian( recieved via email or file upload field).
Then using these files we have upload the data in some excel template which have some predefined formulas. Along with this some pivot charts are also being created, and vLookup is also being used.
Also let me know if we can perform validation of data that is there in the excel.
Kindly help me with all the capabilities of appian related with excel so that i can plan for development accordingly.
Thanks,
Gaurav Singh
Discussion posts and replies are publicly visible
Hi, I would take a look at this recent post ...
https://community.appian.com/discussions/f/data/18201/reg-readexcelsheet-function
It uses the readexcelsheet function that comes with the Excel Tools plugin from the App Market, this would be a good place to get started.
Thanks Dai Williams,
This will help me up with the validation part.
Any input on macros, pivot or vlookup will be appreciated.
Thanks