Hello,
It seems the documentation for the RPA Actions is limited and I would like to know which Action should be used when the need is the robot to update Excel File,
For example I guess one of the following two will be:
Initialization with URL
or
Initialization with File Parameter
Let's assume the file is located on disk C:\Exce\ what parameter should be passed to any of these two actions in order the robot to open the excel and start filling in data after that ?
Discussion posts and replies are publicly visible
In this case, you must use "Initialization with URL" and the URL parameter must be the full path of the Excel file.
But in any case, if you want to filling data in the excel file, I recommend you to use the Appian RPA Excel Library that was recently published in the Appian App Market
https://community.appian.com/b/appmarket/posts/rpa-excel-low-code-methods
It contains more completed methods to interact with Excel.
Hi
I have downloaded Excel low code methods library https://community.appian.com/b/appmarket/posts/rpa-excel-low-code-methods and when i import that zip in import workflow library it is throwing error
How to import this library in Appian RPA?
Is their anyway to create a excel file with dynamic name every month automatically through robotic task?
Thanks in advance
Hi Imayavathi:
From the Appian RPA 9.0.0 version ,it is available two new Excel Modules in the RPA pattern that you must use instead of the library. https://docs.appian.com/suite/help/23.1/rpa-9.0/actions-excel-nolicense.html and https://docs.appian.com/suite/help/23.1/rpa-9.0/actions-excel-license-required.html.
But answering your question, to install the library, you must uncompress first the downloaded file. It contains a Readme.pdf file with the documentation and a zip file with the library ( rpa-excel-low-code-methods-1.2.0.zip )