Python 官方文档:入门教程 => 点击学习
首先需要pip install XlsxWriter#coding=utf-8import xlsxwriter# Create an new excel file and add a worksheet.workbook = xlsxwr
首先需要
pip install XlsxWriter
#coding=utf-8
import xlsxwriter
# Create an new excel file and add a worksheet.
workbook = xlsxwriter.Workbook('demo1.xlsx')
worksheet = workbook.add_worksheet() #新建一个表对象
# Widen the first column to make the text clearer.
worksheet.set_column('A:A', 20) #设置A宽度为20像素
# Add a bold fORMat to use to highlight cells.
#bold = workbook.add_format({'bold': True})
bold = workbook.add_format() #定义一个加粗的格式对象
bold.set_bold()
# Write some simple text.
worksheet.write('A1', 'Hello') #写文字
# Text with formatting.
worksheet.write('A2', 'World', bold)
worksheet.write('B2', u'中文测试', bold)
# Write some numbers, with row/column notation.
worksheet.write(2, 0, 32)
worksheet.write(3, 0, 35.5)
worksheet.write(4, 0, '=SUM(A3:A4)')
# Insert an p_w_picpath.
worksheet.insert_p_w_picpath('B5', 'dog.jpg') #插图片
workbook.close()
--结束END--
本文标题: python写excel
本文链接: https://www.lsjlt.com/news/184839.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-03-01
2024-03-01
2024-03-01
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0