DEV Community

petercour
petercour

Posted on

Write excel from code

You can write Excel files with Python. Excel is a very popular file format outside of the development community. Finance and many other fields heavily use Excel.

The module xlsxwriter lets you do that, first install that module.
Then load the module in Python.

#!/usr/bin/python3
#coding: utf-8
import xlsxwriter
Enter fullscreen mode Exit fullscreen mode

Create a file and a sheet to work in

file_name = "data.xlsx"
workbook = xlsxwriter.Workbook(file_name)
worksheet = workbook.add_worksheet('sheet1')
Enter fullscreen mode Exit fullscreen mode

Write the header to the excel sheet

worksheet.write(0, 0, 'id')
worksheet.write(0,1, 'name')
worksheet.write(0,2, 'class')
worksheet.write(0,3, 'data')
Enter fullscreen mode Exit fullscreen mode

And finally write the data

worksheet.write_row(1, 0, [1, 2, 3])
worksheet.write_column('D2', ['a', 'b', 'c'])

workbook.close()
Enter fullscreen mode Exit fullscreen mode

Put it all together to write the excel file. It gives you this code:

#!/usr/bin/python3
#coding: utf-8
import xlsxwriter

file_name = "data.xlsx"
workbook = xlsxwriter.Workbook(file_name)
worksheet = workbook.add_worksheet('sheet1')

worksheet.write(0, 0, 'id')
worksheet.write(0,1, 'name')
worksheet.write(0,2, 'class')
worksheet.write(0,3, 'data')

worksheet.write_row(1, 0, [1, 2, 3])
worksheet.write_column('D2', ['a', 'b', 'c'])

workbook.close()
Enter fullscreen mode Exit fullscreen mode

Related links:

Top comments (0)