This is the first release of `ExcelSage`, a Python-based library designed to facilitate seamless integration with Robot Framework for advanced Excel operations. It provides powerful tools to read, write, and manipulate Excel sheets programmatically, enhancing automated testing and data management workflows.
Key Features:
- Read data from Excel sheets with customizable parameters (e.g., specific cell ranges, sheet names).
- Write and update Excel sheets directly from Robot Framework test cases.
- Support for various data output formats (e.g., lists, dictionaries) to accommodate different testing scenarios.
- Handling of empty rows and columns to streamline data parsing.
- Comprehensive logging for debugging and tracking.
Compatibility:
- Compatible with Python 3.6 and Robot Framework versions [5.x and above].
- Tested with Excel 2010 and later formats.
Usage:
- Install using `pip install robotframework-excelsage` and view the [documentation](https://deekshith-poojary98.github.io/robotframework-excelsage/) for setup and examples.