在charm里对于excel的操作:
import openpyxl
wb = openpyxl.load_workbook('example.xlsx')
print(wb.sheetnames)
print(wb.active)
sheet = wb['Sheet1']
print(sheet.title)
print(sheet.cell(row=1, column=2).value)
cell = sheet['B1']
print(cell)
print(cell.row, cell.column, cell.value)
print(sheet.max_column)
print(sheet.max_row)
sheet.title = '学生信息'
print(sheet.title)
print(sheet.rows)
for row in sheet.rows:
for cell in row:
print(cell.value, end=',')
print()
excel需求:
import os
import openpyxl
def readwb(wbname, sheetname=None):
wb = openpyxl.load_workbook(wbname)
if not sheetname:
sheet = wb.active
else:
sheet = wb[sheetname]
all_info = []
for row in sheet.rows:
child = [cell.value for cell in row]
all_info.append(child)
return sorted(all_info, key=lambda item: item[1])
def save_to_excel(data, wbname, sheetname='sheet1'):
print("写入Excel[%s]中......." %(wbname))
wb = openpyxl.Workbook()
sheet = wb.active
sheet.title = sheetname
for row, item in enumerate(data):
for column, cellValue in enumerate(item):
sheet.cell(row=row+1, column=column+1, value=cellValue)
wb.save(filename=wbname)
print("写入成功!")