DEV Community

loading...

Write excel from code

petercour
・1 min read

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

Create a file and a sheet to work in

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

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')

And finally write the data

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

workbook.close()

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()

Related links:

Discussion (0)