python写excel
python写excel
首先需要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 image. worksheet.insert_image('B5', 'dog.jpg') #插图片 workbook.close()
热门文章:
相关内容
- 暂无相关文章
评论关闭