Skip to content

Work on xlsx files. Convert to list, dict. Get rows, cols, headers, cell values, positions and more.

License

Notifications You must be signed in to change notification settings

yanemil/xlsxopera

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

xlsxopera

Working on xlsx (Microsoft Excel) files. Convert to list, dict, get headers, cell values, positions and more.

Developed by yanemil (c) 2022

Install

Install package from pip:

pip3 install xlsxopera

Note: Required packages is openpyxl

How to work

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)