2、创建sheet
# 创建sheet
worksheet = workbook.add_worksheet("first_sheet")
3、特定单元格里写入数据
a) 写入文本
# 法一:
worksheet.write...worksheet.write('A3', "python excel", f)
worksheet.set_row(0, 40, f)
worksheet.set_column('A:E', 20, f)
5、批量往单元格写入数据...# 批量往单元格写入数据
worksheet.write_column('A15', [1, 2, 3, 4, 5]) # 列写入,从A15开始
worksheet.write_row('A12',...[6, 7, 8, 9]) # 行写入,从A12开始
6、合并单元格写入
# 合并单元格写入
worksheet.merge_range(7,5, 11, 8, 'merge_range...示例:
# -*- coding:utf-8 -*-
import xlsxwriter
workbook = xlsxwriter.Workbook("data.xlsx")
worksheet