ItSolutionStuff.com

Hello,

This extensive guide will teach you how to create xlsx file in python. I would like to share with you how to generate xlsx file in python. I explained simply step by step how to create a new xlsx file in python. This post will give you a simple example of python create xlsx file example.

There are several modules and ways to create xlsx files in python. i will give you simple three examples using pandas, openpyxl and xlsxwriter to generate xlsx file data. so let's see examples one by one.

You can use these examples with python3 (Python 3) version.

Example 1: using pandas

If you haven't install pandas in your system then you can install using the below command:

pip install pandas 

main.py

import pandas as pd # Create DataFrame for XLSX File df = pd.DataFrame({'ID': [1, 2, 3], 'Name': ["Hardik Savani", "Vimal Kashiyani", "Harshad Pathak"], 'Email': ["hardik@gmail.com", "vimal@gmail.com", "harshad@gmail.com"]}) # Create a Pandas Excel writer using XlsxWriter writer = pd.ExcelWriter('demo.xlsx', engine='xlsxwriter') # Convert the dataframe to an XlsxWriter Excel object. df.to_excel(writer, sheet_name='Sheet1', index=False) # Save Data to File writer.save() 

Output:

Now, It will generated demo.xlsx file in your root path with the below content.

demo.xlsx

Example 2: using openpyxl

If you haven't install openpyxl in your system then you can install using the below command:

pip install openpyxl 

main.py

import openpyxl # Define variable to load the dataframe wb = openpyxl.Workbook() # Define active sheet sheet = wb.active # Create List for store data data =[('ID', 'Name', 'Email'), (1, 'Hardik Savani', 'hardik@gmail.com'), (2, 'Vimal Kashiyani', 'vimal@gmail.com'), (3, 'Harshad Pathak', 'harshad@gmail.com')] # Adding Data to Sheet for item in data : sheet.append(item) # Save File wb.save("demo.xlsx") 

Output:

Now, It will generated demo.xlsx file in your root path with the below content.

demo.xlsx

Example 3: using xlsxwriter

If you haven't install xlsxwriter in your system then you can install using the below command:

pip install xlsxwriter 

main.py

import xlsxwriter # Cretae a xlsx file xlsx_File = xlsxwriter.Workbook('demo.xlsx') # Add new worksheet sheet_schedule = xlsx_File.add_worksheet() # Create List for write data into xlsx file data = [ { "ID": 1, "Name": "Hardik Savani", "Email": "hardik@gmail.com"}, { "ID": 2, "Name": "Vimal Kashiyani", "Email": "vimal@gmail.com"}, { "ID": 3, "Name": "Harshad Pathak", "Email": "harshad@gmail.com"} ] row = 1 column = 0 # Set Header for xlsx file sheet_schedule.write(0, 0, "ID") sheet_schedule.write(0, 1, "Name") sheet_schedule.write(0, 2, "Email") # write into the worksheet for item in data : # write operation perform sheet_schedule.write(row, 0, item["ID"]) sheet_schedule.write(row, 1, item["Name"]) sheet_schedule.write(row, 2, item["Email"]) # incrementing the value of row by one row += 1 # Close the Excel file xlsx_File.close() 

Output:

Now, It will generated demo.xlsx file in your root path with the below content.

demo.xlsx

I hope it can help you...