I have a question related to "Appian RPA - working with Excel": is the set of activities powerful enough?
I have a project that requires specific activities in a few Excel files:
-renaming a sheet
-adding/removing a sheet
-applying sorting
-transferring (copy and paste) data from one sheet to another one in the same Excel documents and between documents
-searching in a column for the first file name (the column has files names in it) that has or not an extension (".txt" for example).
etc etc etc
Can the Appian "working with Excel" set of activities powerful enough? Did somebody have something that couldn't be implemented (lack of functionality maybe)?
I have to choose between "Appian RPA" and "MS power automation", I don't want to start with "Appian RPA" and to realize afterwards that it cannot do this and that, etc.
Thank you so much.
Discussion posts and replies are publicly visible
Appian Smart Services can't handle your requirements - it only does basic import/export. Appian RPA (Excel: License Required module) supports all your needs like renaming sheets, sorting, copying data, and searching columns.