exex 0.1.7

Extract data from Excel documents.

exex

Extract data from Excel documents

Installation

pip install exex

Usage

from openpyxl import load_workbook
from exex import parse

book = load_workbook("sample.xlsx") # load excel file
sheet = book.active # get active sheet

# single cell by name
parse.values(sheet["A1"])
"name"                    

# single cell by row/column number
parse.values(sheet.cell(row=1, column=1)) 
"name"
   
# range of cells
parse.values(sheet["A1":"B2"])
[
  ["name", "abbreviation"],
  ["alpha", "a"],
]

# all values              
parse.values(sheet.values)
[
  ["name", "abbreviation", "age"],
  ["alpha", "a", 1],
  ["beta", "b", 2],
  ["gamma", "g", 3],
]

# row by number                  
parse.values(sheet[1])
["alpha", "a", 1]
           
# range of rows           
parse.values(sheet[1:2])
[
  ["name", "abbreviation", "age"],
  ["alpha", "a", 1],
]

# column by name            
parse.values(sheet["A"])
["name", "alpha", "beta", "gamma"]

# column range
parse.values(sheet["A:B"])
[
  ["name", "alpha"],
  ["abbreviation", "a"],
]

Ways to access sheets

# Sheets
book.sheets[0]                # (sheet) sheet by index
book.sheets["prices"]         # (sheet) sheet by name
book.active                   # (sheet) active sheet

book.sheetnames               # (array) sheet names

Development

Tests (local Python version)

poetry run pytest

Tests (all Python versions defined in tox.ini)

poetry run tox

Code formatting (black)

poetry run black .