🚀 Introducing ExcelSage: A Powerful Excel Library for Robot Framework

:rocket: Introducing ExcelSage: A Powerful Excel Library for Robot Framework

Hello Robot Framework Community! :waving_hand:

I’m excited to introduce ExcelSage, a powerful and feature-rich library for working with Excel files in Robot Framework. :bullseye:

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.

:fire: Key Features:

:white_check_mark: Read & write data to Excel effortlessly
:white_check_mark: Find & replace values within sheets
:white_check_mark: Sort, filter, and remove duplicates
:white_check_mark: Merge multiple Excel files
:white_check_mark: Protect/unprotect sheets & workbooks
:white_check_mark: Apply direct formatting (font, color, alignment)
:white_check_mark: Insert & delete rows/columns dynamically
:white_check_mark: Works with Excel 2010+ (.xlsx)

:books: Documentation

You can find the keyword documentation here.

:rocket: 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

:pushpin: GitHub Repository

:link: ExcelSage on GitHub

3 Likes