Python XlsxWriter - Hello World

Getting Started

The first program to test if the module/pbrary works correctly is often to write Hello world message. The following program creates a file with .XLSX extension. An object of the Workbook class in the xlsxwriter module corresponds to the spreadsheet file in the current working directory.

wb = xlsxwriter.Workbook( hello.xlsx )

Next, call the add_worksheet() method of the Workbook object to insert a new worksheet in it.

ws = wb.add_worksheet()

We can now add the Hello World string at A1 cell by invoking the write() method of the worksheet object. It needs two parameters: the cell address and the string.

ws.write( A1 ,  Hello world )

Example

The complete code of hello.py is as follows −

import xlsxwriter
wb = xlsxwriter.Workbook( hello.xlsx )
ws = wb.add_worksheet()
ws.write( A1 ,  Hello world )
wb.close()

Output

After the above code is executed, hello.xlsx file will be created in the current working directory. You can now open it using Excel software.