Getting Started

The first program to test if the module/library 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.