# 🚀 Introducing ExcelSage: A Powerful Excel Library for Robot Framework

**URL:** <https://forum.robotframework.org/t/introducing-excelsage-a-powerful-excel-library-for-robot-framework/8647>\
**Category:** Libraries\
**Created:** [15 March 2025 09:25 UTC](https://forum.robotframework.org/t/introducing-excelsage-a-powerful-excel-library-for-robot-framework/8647 "2025-03-15T09:25:14Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Deekshith](https://dub1.discourse-cdn.com/flex005/user_avatar/forum.robotframework.org/deekshith/32/3078_2.png) [@Deekshith](https://forum.robotframework.org/u/Deekshith)\
**Post date:** [15 March 2025 09:25 UTC](https://forum.robotframework.org/t/introducing-excelsage-a-powerful-excel-library-for-robot-framework/8647/1 "2025-03-15T09:25:15Z")

</div>

## 🚀 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](https://deekshith-poojary98.github.io/robotframework-excelsage/).

### 🚀 Installation & Usage:

Install using pip:

```bash
pip install robotframework-excelsage

```

Then, use it in your Robot Framework test cases:

```robot
***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](https://github.com/deekshith-poojary98/robotframework-excelsage)