python xlswriter_python-写入excel(xlswriter)

一、安装XlsxWriter模块

pip install XlsxWriter

二、常用方法

importxlsxwriterimportdatetime

workbook= xlsxwriter.Workbook("new_excel.xlsx") #创建Excel

worksheet= workbook.add_worksheet("first_sheet") #添加sheet#写入文本#法一：

worksheet.write('A1', 'write something,this is A1')#法二：

worksheet.write(1, 0, 'hello A2')#写入数字

worksheet.write(0, 1, 32) #B1 = 32

worksheet.write(1, 1, 32.3) #B2 = 32.3#写入函数

worksheet.write(2, 1, '=sum(B1:B2)') #B3 = 64.3#插入图片

worksheet.insert_image(0, 5, '2.jpeg')#worksheet.insert_image(0, 5, 'test.png', {'url': 'http://httpbin.org/'})#写入日期

d = workbook.add_format({'num_format': 'yyyy-mm-dd'})

worksheet.write(0,2, datetime.datetime.strptime('2019-12-17', '%Y-%m-%d'), d) #C1#设置行属性，