Introducing ExcelSage: A Powerful Excel Library for Robot Framework
Hello Robot Framework Community!
I’m excited to introduce ExcelSage, a powerful and feature-rich library for working with Excel files in Robot Framework.
Why ExcelSage?
While existing libraries like ExcelLibrary
or ExcellentLibrary
provide basic Excel operations, ExcelSage goes further with 40+ advanced keywords to make Excel automation smoother and more efficient.
Key Features:
Read & write data to Excel effortlessly
Find & replace values within sheets
Sort, filter, and remove duplicates
Merge multiple Excel files
Protect/unprotect sheets & workbooks
Apply direct formatting (font, color, alignment)
Insert & delete rows/columns dynamically
Works with Excel 2010+ (.xlsx)
Documentation
You can find the keyword documentation here.
Installation & Usage:
Install using pip:
pip install robotframework-excelsage
Then, use it in your Robot Framework test cases:
*** Settings ***
Library ExcelSage
*** Variables ***
${EXCEL_PATH} path/to/excel.xlsx
*** Test Cases ***
Test Opening Workbook
Open Workbook ${EXCEL_PATH}
Test Fetching Sheet Data
${data}= Fetch Sheet Data sheet_name=Sheet1 output_format=dataframe
Log ${data}
Test Writing to Cell
Write To Cell A1 Test Data Sheet1
Test Appending Row
Append Row row_data=["John", 28, "Engineer"] sheet_name=Sheet1
Test Formatting Cell
Format Cell A1 font_size=12 font_color=FF0000 sheet_name=Sheet1 bold=True bg_color=FFFF00
Test Protecting Sheet
Protect Sheet password=my_password sheet_name=Sheet1
GitHub Repository
ExcelSage on GitHub