from openpyxl import *
# 新建一份excel文件
def write_new_excel():
#1、 构建workbook --excel文件.xlsx
work_book = Workbook()
# 2、构建sheet
sheet = work_book.active
# 3、设置sheet的title
sheet.title = '学生信息'
# 4、表格head
sheet['A1'] = '姓名'
sheet['B1'] = '电话'
sheet['C1'] = '地址'
sheet['D1'] = '性别'
sheet['E1'] = '爱好1'
sheet['F1'] = '爱好2'
# 5、写入到excel
work_book.save(filename='stuinfo.xlsx')
write_new_excel()
写入数据
from openpyxl import *
# 新建一份excel文件
def write_new_excel():
#1、 构建workbook --excel文件.xlsx
work_book = Workbook()
# 2、构建sheet
sheet = work_book.active
# 3、设置sheet的title
sheet.title = '学生信息'
# 4、表格head
sheet['A1'] = '姓名'
sheet['B1'] = '电话'
sheet['C1'] = '地址'
sheet['D1'] = '性别'
sheet['E1'] = '爱好1'
sheet['F1'] = '爱好2'
# 5、写入到excel
work_book.save(filename='stuinfo.xlsx')
# 写数据
def write_data_excel():
# 1、加载已存在的文件
work_book = load_workbook('stuinfo.xlsx')
# 2、获取sheet
sheet = work_book.active
# 3、写入数据
# 第一种方式:按照单元格依次写入
# sheet['A2'] = '张三'
# sheet['B2'] = '12537474747'
# sheet['C2'] = '石家庄'
# sheet['D2'] = '男'
# sheet['E2'] = '体育'
# sheet['F2'] = '文艺'
# 第二种方式: 通过循环写入
# 获取当前最大行数
max_row = sheet.max_row
# print(max_row)
row = max_row + 1
# 获取最大列数
max_column = sheet.max_column
# print (max_column)
# 构建写入数据
stu_info = ['李四', '1839384763', '河北', '男', '音乐', '运动']
# range 是从哪到哪,包左不包右,所以+1
for data_cell in range(1, max_column+1):
# 从最大行数开始写,列就是当前循环的数,值要减1因为列表的索引从0开始
sheet.cell(row=row, column=data_cell, value=stu_info[data_cell-1])
# 4、保存数据
work_book.save(filename='stuinfo.xlsx')
write_data_excel()