openpyxl-autofill 0.2.2

针对openpyxl的功能扩展

Installation via pip

pip install openpyxl_autofill

Usage

from openpyxl import load_workbook
import openpyxl_autofill
openpyxl_autofill.enable_all()
wb = load_workbook(...)
ws = wb.active
ws.insert_rows(...)
...

Extensions for openpyxl

sort

Sorts the cells within the given range.

insert

Insert rows and insert cols. Auto adjust merged cells, formulas and tables.

delete

Delete rows and delete cols. Auto adjust merged cells, formulas and tables.