Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
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.