pyexcel

import pyexcel from collections import OrderedDict # --- Writing data to an Excel file (e.g., 'your_file.xlsx') --- data = OrderedDict() data.update({"Sheet 1": [[1, 2, 3], [4, 5, 6]]}) data.update({"Sheet 2": [['a', 'b', 'c'], ['d', 'e', 'f']]}) # Ensure pyexcel-xlsx is installed: pip install pyexcel-xlsx pyexcel.save_book_as(bookdict=data, dest_file_name="your_file.xlsx") print("Data written to your_file.xlsx") # --- Reading data from an Excel file --- # Ensure pyexcel-xlsx is installed: pip install pyexcel-xlsx sheet = pyexcel.get_sheet(file_name="your_file.xlsx") print(f"Content of Sheet 1 (as array): {sheet.array}") # You can also get the whole book as a dictionary of sheets book_dict = pyexcel.get_book_dict(file_name="your_file.xlsx") print(f"Content of the entire book: {book_dict}")