Please note: This RPA Utility has been archived because the functionality is now available via out-of-the-box Appian RPA actions
Overview
During an automation in RPA we often need to interact with Excel files to extract or save information.
With this library, based on Apache POI, you can interact with your Excel files using simple Low Code methods.
Key Features & Functionality
With this library we will be able to:
This library is based on Apache POI, This library does not require open the Excel Application.
In any case, this library is already archive, you can use the Appian RPA modules
https://docs.appian.com/suite/help/23.2/rpa-9.1/actions-excel-nolicense.html
https://docs.appian.com/suite/help/23.2/rpa-9.1/actions-excel-license-required.html
Does the "Open or Create a new Excel file" function work with XLSM files? I'm noticing that the execution log shows the file being opened with no issues, but the Excel application nor the file itself appears to open on my desktop
Uploaded version 1.1.0 with a new CheckBox "Write as Formula" in the "Write to Workbook" method