- 表格创建
import xlwt
workbook = xlwt.Workbook()
worksheet = workbook.add_sheet('My Worksheet')
worksheet.write(0, 0, label = 'Row 0, Column 0 Value')
workbook.save('Excel_Workbook.xls')
- 表格读取
import openpyxl
file = r'e:\分数表.xlsx'
workbook = openpyxl/load_workbook('文件名')
sheet = workbok['sheet1']
x = sheet.cell(4,3).value
a = sheet['A1']
a.value
a.column
a.row
sheet.max_row
sheet.max_column
for i in range(1,10):
print(sheet.cell(row = i, column = 2).value
list(sheet.columns)
list(sheet.columns)[0]
list(sheet.rows)
list(sheet.rows)[0]