openpyxl
写入
from openpyxl import Workbook
wb = Workbook()
wb1 = wb.create_sheet('index', 0)
wb1['D2'] = 'alsidhf'
wb1.cell(4,2,'11111111111')
wb1['A1'] = 4
wb1['A2'] = 3
wb1['A3'] = '=sum(A1:A2)'
wb1.append([])
wb1.append([])
wb1.append([])
wb1.append([])
wb1.append([])
wb1.append([1,2,3,4,5,6,7,8,9])
wb1.title = 'user'
wb.save('a.xlsx')
读取
from openpyxl import load_workbook wb = load_workbook('a.xlsx') print(wb.sheetnames) wb1 = wb['user'] print(wb1['A2'].value) print(wb1.cell(2,1).value) print(wb1.max_row) print(wb1.max_column) print(wb1.rows) print(wb1.columns) a = wb1.rows b = wb1.columns print(type(a), a) print('#############') qq = a.__next__() print(qq) print(a.__next__()) print(a.__next__()) print(a.__next__()) print(a.__next__()) print(a.__next__()) print(a.__next__()) print(b) print('#############') print([el.value for el in qq])
# 输出
['user', 'Sheet'] 3 3 10 9 <generator object Worksheet._cells_by_row at 0x000001569253E570> <generator object Worksheet._cells_by_col at 0x000001569253E570> <class 'generator'> <generator object Worksheet._cells_by_row at 0x000001569253E570> ############# (<Cell 'user'.A1>, <Cell 'user'.B1>, <Cell 'user'.C1>, <Cell 'user'.D1>, <Cell 'user'.E1>, <Cell 'user'.F1>, <Cell 'user'.G1>, <Cell 'user'.H1>, <Cell 'user'.I1>) (<Cell 'user'.A2>, <Cell 'user'.B2>, <Cell 'user'.C2>, <Cell 'user'.D2>, <Cell 'user'.E2>, <Cell 'user'.F2>, <Cell 'user'.G2>, <Cell 'user'.H2>, <Cell 'user'.I2>) (<Cell 'user'.A3>, <Cell 'user'.B3>, <Cell 'user'.C3>, <Cell 'user'.D3>, <Cell 'user'.E3>, <Cell 'user'.F3>, <Cell 'user'.G3>, <Cell 'user'.H3>, <Cell 'user'.I3>) (<Cell 'user'.A4>, <Cell 'user'.B4>, <Cell 'user'.C4>, <Cell 'user'.D4>, <Cell 'user'.E4>, <Cell 'user'.F4>, <Cell 'user'.G4>, <Cell 'user'.H4>, <Cell 'user'.I4>) (<Cell 'user'.A5>, <Cell 'user'.B5>, <Cell 'user'.C5>, <Cell 'user'.D5>, <Cell 'user'.E5>, <Cell 'user'.F5>, <Cell 'user'.G5>, <Cell 'user'.H5>, <Cell 'user'.I5>) (<Cell 'user'.A6>, <Cell 'user'.B6>, <Cell 'user'.C6>, <Cell 'user'.D6>, <Cell 'user'.E6>, <Cell 'user'.F6>, <Cell 'user'.G6>, <Cell 'user'.H6>, <Cell 'user'.I6>) (<Cell 'user'.A7>, <Cell 'user'.B7>, <Cell 'user'.C7>, <Cell 'user'.D7>, <Cell 'user'.E7>, <Cell 'user'.F7>, <Cell 'user'.G7>, <Cell 'user'.H7>, <Cell 'user'.I7>) <generator object Worksheet._cells_by_col at 0x000001569253E780> ############# [4, None, None, None, None, None, None, None, None]