Skip to main content
V
vladimirv0001
September 8, 2022
Solved

Appian RPA Open Excel FIle

  • September 8, 2022
  • 4 replies
  • 0 views

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 ?

    Best answer by david.catalan

    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 )

    4 replies

    joseantoniog3161
    joseantoniog3161
    November 18, 2022

    Try this route: C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE, where root its your name especific user folder

    D
    david.catalan
    December 7, 2022

    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.

    I
    imayavathia8970
    April 17, 2023

    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

    D
    david.catalanAnswer
    April 17, 2023

    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 )

      Terms & ConditionsAccessibility statement