Welcome folks today in this blog post we will be creating excel file using xlsxwriter module. All the source code of the project is given below.
Get Started
In order to get started you need to install xlsxwriter module by pip command in python
pip install xlsxwriter
After installing it you need to make a app.py file and copy paste the following code
app.py
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
# import xlsxwriter module import xlsxwriter # Workbook() takes one, non-optional, argument # which is the filename that we want to create. workbook = xlsxwriter.Workbook('carsData1.xlsx') # The workbook object is then used to add new # worksheet via the add_worksheet() method. worksheet = workbook.add_worksheet() # Use the worksheet object to write # data via the write() method. worksheet.write('A1', 'Name') worksheet.write('B1', 'Age') worksheet.write('C1', 'Subject') worksheet.write('D1', 'Country') # Finally, close the Excel file # via the close() method. workbook.close() |
Now if you execute this app.py file you will see the following output excel file will be created
Now we will see a second example in which we will be populating values inside different rows
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
# import xlsxwriter module import xlsxwriter workbook = xlsxwriter.Workbook('Example2.xlsx') worksheet = workbook.add_worksheet() # Start from the first cell. # Rows and columns are zero indexed. row = 0 column = 0 content = ["ankit", "rahul", "priya", "harshita", "sumit", "neeraj", "shivam"] # iterating through content list for item in content : # write operation perform worksheet.write(row, column, item) # incrementing the value of row by one # with each iteratons. row += 1 workbook.close() |
Now we will create another which will fill both rows and columns
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 |
# import xlsxwriter module import xlsxwriter workbook = xlsxwriter.Workbook('Example3.xlsx') # By default worksheet names in the spreadsheet will be # Sheet1, Sheet2 etc., but we can also specify a name. worksheet = workbook.add_worksheet("My sheet") # Some data we want to write to the worksheet. scores = ( ['ankit', 1000], ['rahul', 100], ['priya', 300], ['harshita', 50], ) # Start from the first cell. Rows and # columns are zero indexed. row = 0 col = 0 # Iterate over the data and write it out row by row. for name, score in (scores): worksheet.write(row, col, name) worksheet.write(row, col + 1, score) row += 1 workbook.close() |
