How to Wrap Text in Excel using Python

Working with Excel files is a standard part of any data handler’s duty. This holds if you’re a data analyst trying to process business info, or a web developer looking to parse Excel data for use in a web application.

One task in the Excel-Challenge is wrapping text in cells. In this tutorial, we are going to learn how to wrap text in Excel using Python. We will use the openpyxl module, a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm files.

Step 1: Install the Required Module

First of all, you will need to install the openpyxl module. You can do this with pip, a package installer for Python. Use the following command to install the openpyxl module:

1	pip install openpyxl

Step 2: Import the Required Module

Next, you need to import the openpyxl module to your Python script. To do this, use the following line of code:

1	from openpyxl import Workbook

Step 3: Create a New Workbook

After you’ve imported the module, you need to create a new Excel workbook. This can be done with the following code:

1	wb = Workbook()

Step 4: Select the Active Worksheet

Now, let’s select the active worksheet so we can begin manipulating data:

1	ws = wb.active

Step 5: Wrap Text in a Cell

For this step, let’s input some text in a cell and set the text wrap option to True:

cell = ws['A1']

cell.value = "This is a pretty long string"

cell.alignment = Alignment(wrap_text=True)

These examples define text to be placed in cell A1 of the Excel file and then apply the text wrap option to it.

Step 6: Save the Workbook

The final step is to save the workbook. This writes changes to the disc using the workbook.save method:

1	wb.save("wrap_text.xlsx")

Here’s the full code:

from openpyxl import Workbook

from openpyxl.styles import Alignment

wb = Workbook()

ws = wb.active