Python处理Excel文件:openpyxl
OpenPyxl是一个Python库,用于读取/写入Excel 2010 XLSX/XLSM/XLTX/XLTM文件。
要处理xls,参考使用 xlrd/xlwd
安装组件openpyxl
$ pip install openpyxl
- 要处理图片,还需要进下安装
$ pip install pillow
读取Excel
>>> from openpyxl import load_workbook
>>> wb = load_workbook(filename = 'empty_book.xlsx')
>>> sheet_ranges = wb['range names']
>>> print(sheet_ranges['D18'].value)
>>> wb.close()
3
创建Excel
>>> from openpyxl import Workbook
>>> wb = Workbook()
>>> ws = wb.active
>>> # add a simple formula
>>> ws["A1"] = "=SUM(1, 1)"
>>> wb.save("formula.xlsx")
>>> wb.close()
编辑现有Excel
>>> from openpyxl import Workbook
# 打开文件
>>> wb = load_workbook(filename = 'formula.xlsx')
# 这里与创建时的有区别,注意。是读取指定sheet
>>> sheet_ranges = wb['range names']
>>> # add a simple formula
>>> ws["A1"] = "25"
# 保存文件,与打开的一致
>>> wb.save("formula.xlsx")
>>> wb.close()