In this article we want to learn how to Create Excel Files with Python, as you know that Python is popular programming language, you can use Python for different tasks, like working with Excel files. and there are different Python libraries, that you can use for working with Excel files, One popular library for writing data to Excel files in the older .xls format is xlwt. In this article we are going to explore what xlwt is, how to install it and some examples of how to use it in Python.
What is xlwt?
xlwt is Python library for writing data to Excel files in the older .xls format. It was created by John Machin and is currently maintained by Python Packaging Authority. xlwt allows you to create new Excel files, write data to them and control formatting.
How to Install xlwt ?
For the installation of xlwt, you can use pip, simply open your command prompt or terminal and write this command.
|
1 |
pip install xlwt |
Creating New Excel Workbook in Python
First of all let’s use xlwt to create new Excel file. You can do this by using Workbook() function. This is an example:
|
1 2 3 4 |
import xlwt workbook = xlwt.Workbook() worksheet = workbook.add_sheet('Sheet 1') |
This code creates a new Excel file with one worksheet and store it in the workbook variable.
Writing Data to Excel Cell in Python
When you have created the worksheet, you can begin writing data to it. you can write string, number, or formula to cell using the write() method. This is an example:
|
1 |
worksheet.write(0, 0, 'Hello, world') |
Setting Cell Formatting
also xlwt allows you to control cell formatting, such as font, alignment and background color. This is an example:
|
1 2 3 4 5 6 7 8 9 10 11 12 |
style = xlwt.XFStyle() font = xlwt.Font() font.bold = True style.font = font alignment = xlwt.Alignment() alignment.horz = xlwt.Alignment.HORZ_CENTER style.alignment = alignment pattern = xlwt.Pattern() pattern.pattern = xlwt.Pattern.SOLID_PATTERN pattern.pattern_fore_colour = xlwt.Style.colour_map['gray25'] style.pattern = pattern worksheet.write(0, 0, 'Hello, world!', style) |
Saving the Workbook
when you have finished writing data to worksheet you can save the Excel file using the save() method. this is an example:
|
1 |
workbook.save('example.xls') |
This is the complete code
|
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 xlwt # Creating a new workbook workbook = xlwt.Workbook() worksheet = workbook.add_sheet('Sheet 1') # Writing data to a cell worksheet.write(0, 0, 'Hello, world') # Setting cell formatting style = xlwt.XFStyle() font = xlwt.Font() font.bold = True style.font = font alignment = xlwt.Alignment() alignment.horz = xlwt.Alignment.HORZ_CENTER style.alignment = alignment pattern = xlwt.Pattern() pattern.pattern = xlwt.Pattern.SOLID_PATTERN pattern.pattern_fore_colour = xlwt.Style.colour_map['gray25'] style.pattern = pattern # Saving the workbook workbook.save('example.xls') |
FAQs:
Can I use Python with Excel?
Yes, you can use Python with Excel. There are several libraries available in Python that you can use for reading and writing to Excel files, manipulate data and automate tasks. Some popular libraries for working with Excel in Python are xlrd, xlwt, openpyxl, and pandas.
Can you combine Excel with Python?
Yes, Python provides different libraries for working with Excel files. You can use Python to automate tasks, perform data analysis, generate reports and manipulate Excel files in different ways.
Subscribe and Get Free Video Courses & Articles in your Email