aspose-cells

Create a Python-based mini-application named 'ExcelSheetManager' that leverages the Aspose.Cells library to provide advanced Excel file manipulation capabilities. This application will allow users to perform various operations on Excel files, such as merging multiple Excel files into one, splitting a large Excel file into smaller ones based on specific criteria, converting between different Excel file formats, and extracting data from specific sheets or ranges within an Excel file. Additionally, the app should be able to generate charts from the provided data and save these charts back into the Excel file. Here’s a detailed breakdown of the steps and functionalities you need to implement:

1. **Setup Environment**: Ensure you have Python installed along with the Aspose.Cells library. You might also want to include other necessary libraries like pandas for data handling.
2. **User Interface**: Develop a simple command-line interface (CLI) for user interaction. The CLI should present options like 'Merge Excel Files', 'Split Excel File', 'Convert File Format', 'Extract Data', and 'Generate Charts'.
3. **File Handling Functions**:
   - **Merging Excel Files**: Implement a function that takes multiple Excel files as input and merges them into a single output file, ensuring that each original file’s sheet names and contents are preserved.
   - **Splitting Excel File**: Create a function that splits a large Excel file into smaller files based on a specified number of rows or columns per file.
4. **Format Conversion**: Allow conversion between supported Excel formats (XLS, XLSX, XLSB, ODS, CSV, HTML) while maintaining the integrity of the data and any existing formatting.
5. **Data Extraction**: Design a feature where users can specify a range or a sheet name from which data needs to be extracted. The extracted data should then be saved to a new Excel file or another format.
6. **Chart Generation**: Include functionality to generate charts (such as bar charts, line charts, etc.) from the data within an Excel file and save these charts back into the same or a new Excel file.
7. **Error Handling and Validation**: Make sure your application handles errors gracefully, providing meaningful messages to users when something goes wrong, such as invalid file paths or unsupported file formats.
8. **Testing**: Write test cases to validate each functionality of your application, ensuring everything works as expected.
9. **Documentation**: Provide clear documentation on how to use the application, including setup instructions and examples of each feature in action.

By following these steps, you’ll create a versatile tool that can be used for managing and manipulating Excel files efficiently, all powered by the robust capabilities of Aspose.Cells.