Working on xlsx (Microsoft Excel) files. Convert to list, dict, get headers, cell values, positions and more.
Developed by yanemil (c) 2022
Install package from pip:
pip3 install xlsxopera
Note: Required packages is openpyxl
Create an object
from xlsxopera import Notebook
# Load file to operate and sheet name
notebook = Notebook("file-to-path.xlsx", "sheet_name")
# Or load file to operate without sheet name. Default will be active spreadsheet.
notebook = Notebook("file-to-path.xlsx")Get rows in list of lists:
# Get all rows (from 1 to last)
rows_in_spreadsheet = notebook.list_rows()
# Get rows (for e.g, from 9 to 13)
rows_in_spreadsheet = notebook.list_rows(start=9, end=13)