Skip to footer content
USING IRONXL FOR PYTHON

How to Insert image into Excel Using Python

For data analysis and reporting in modern applications, Microsoft Excel remains one of the most widely used tools. Python, with its robust ecosystem of libraries, offers a powerful way to automate and enhance the functionality of Microsoft Excel. One such library is IronXL, which allows users to work with Excel files in an intuitive and efficient manner. This article will guide you through the process of inserting images into Excel using IronXL in Python.

How to Insert an Image into Excel Using Python

  1. Install the IronXL Python package.
  2. Create or Open an Excel Workbook.
  3. Select the Worksheet where the image will be inserted.
  4. Insert the Image at a specified location.
  5. Save the Workbook.

What is IronXL?

IronXL is a .NET library that simplifies the process of reading, writing, and manipulating Excel files. It is particularly advantageous for developers who want to work with Excel documents without requiring Microsoft Office installed on their machine. IronXL provides a straightforward API to handle various Excel functionalities, including creating spreadsheets, formatting cells, and inserting images. In Python, we can make use of the IronXL library through the IronXL for Python package. You can find the complete API documentation here.

Prerequisites

Before we dive into the code, ensure that you have the following prerequisites:

  1. Python Installed: Make sure you have Python installed on your machine. You can download it from the official Python website.
  2. IronXL Installed: You need to install the IronXL package. You can do this using pip.
  3. Image File: Have an image file ready that you want to insert into your Excel sheet. Supported formats typically include JPEG, PNG, and BMP.

Steps for Python Insert Image to Excel File

The process of inserting an image into an Excel spreadsheet involves the following basic steps:

Step 1: Install the IronXL for Python Package.

Make sure you have created a Python file with a .py extension. Now install the IronXL package using pip:

pip install IronXL
pip install IronXL
SHELL

Step 2: Create or Open an Excel Workbook.

Create an Excel file or open an existing Excel file using IronXL.

import ironxl

# To create a new Excel workbook
workbook = ironxl.Workbook()

# Or to open an existing Excel workbook
workbook = ironxl.Workbook('existing_file.xlsx')
import ironxl

# To create a new Excel workbook
workbook = ironxl.Workbook()

# Or to open an existing Excel workbook
workbook = ironxl.Workbook('existing_file.xlsx')
PYTHON

Step 3: Select the Worksheet where the image will be inserted.

# Create a new worksheet
worksheet = workbook.add_worksheet('Sheet1')

# Or access an existing worksheet
worksheet = workbook.get_worksheet('Sheet1')

# Alternatively, use the default worksheet
worksheet = workbook.DefaultWorkSheet
# Create a new worksheet
worksheet = workbook.add_worksheet('Sheet1')

# Or access an existing worksheet
worksheet = workbook.get_worksheet('Sheet1')

# Alternatively, use the default worksheet
worksheet = workbook.DefaultWorkSheet
PYTHON

Step 4: Insert the Image at a Specified Location.

# Specify the path to your image file
image_path = "ironXL.jpg"
# Specify the cell where you want to insert the image
cell_location = 'B2'
# Insert the image into the specified cell
worksheet.insert_image(cell_location, image_path)
# Specify the path to your image file
image_path = "ironXL.jpg"
# Specify the cell where you want to insert the image
cell_location = 'B2'
# Insert the image into the specified cell
worksheet.insert_image(cell_location, image_path)
PYTHON

Step 5: Save the Workbook.

# Save the workbook with the desired filename
workbook.save('AwesomeIronXL.xlsx')
# Save the workbook with the desired filename
workbook.save('AwesomeIronXL.xlsx')
PYTHON

Full Code Example

import ironxl

# Step 1: Create a new Excel workbook or open an existing one
workbook = ironxl.Workbook()  # For a new Excel file
# workbook = ironxl.Workbook('existing_file.xlsx')  # For an existing workbook

# Step 2: Select a worksheet from a list of worksheets or create a new one
# worksheet = workbook.add_worksheet('Sheet1')  # Create a new worksheet
# worksheet = workbook.get_worksheet('Sheet1')  # Access an existing worksheet
worksheet = workbook.DefaultWorkSheet

# Step 3: Insert an image
image_path = "ironXL.jpg"  # Path to your image file
cell_location = 'B2'  # Specify the Excel cell for image insertion
worksheet.insert_image(cell_location, image_path)  # Insert the image

# Step 4: Save the workbook
workbook.save('AwesomeIronXL.xlsx')
import ironxl

# Step 1: Create a new Excel workbook or open an existing one
workbook = ironxl.Workbook()  # For a new Excel file
# workbook = ironxl.Workbook('existing_file.xlsx')  # For an existing workbook

# Step 2: Select a worksheet from a list of worksheets or create a new one
# worksheet = workbook.add_worksheet('Sheet1')  # Create a new worksheet
# worksheet = workbook.get_worksheet('Sheet1')  # Access an existing worksheet
worksheet = workbook.DefaultWorkSheet

# Step 3: Insert an image
image_path = "ironXL.jpg"  # Path to your image file
cell_location = 'B2'  # Specify the Excel cell for image insertion
worksheet.insert_image(cell_location, image_path)  # Insert the image

# Step 4: Save the workbook
workbook.save('AwesomeIronXL.xlsx')
PYTHON

Explanation of the Code

  1. Creating/Opening a Workbook: You can either create a new workbook or open an existing one using the ironxl.Workbook() function. For an existing Excel file, ensure you provide the correct file path to the workbook.

  2. Selecting a Worksheet: Use add_worksheet() to add a new worksheet or get_worksheet() to access an existing worksheet.

  3. Inserting the Image: The insert_image() method is used to insert the image. You need to specify the cell and image file path/attribute where the image will be inserted.

  4. Saving the Workbook: Use the save() method to save the workbook with the desired filename.

Additional Considerations

Image Size and Formatting

When inserting images, consider the size and aspect ratio to fit well within the cells. Resize your image beforehand or use additional methods to adjust its dimensions post-insertion.

Error Handling

Implement error handling to manage scenarios such as file not found, unsupported file formats, or issues with the Excel file itself. Using try-except blocks helps manage exceptions gracefully.

Dependencies and Limitations

While IronXL is powerful, be aware of its dependencies and licensing. Ensure compliance with the licensing terms and be aware of any limitations in the free version.

License (Trial Available)

Users need to include a trial license to use IronXL. Include the license in the code as below:

import ironxl
ironxl.License.LicenseKey = "Your License"
import ironxl
ironxl.License.LicenseKey = "Your License"
PYTHON

You can get complete information on the license here.

Conclusion

Inserting images into Excel using Python and IronXL enhances the visual appeal of your spreadsheets, making them more engaging for reporting, presentations, or data visualization. With the outlined steps, automate image insertion to save time and improve data handling efficiency.

As you grow acquainted with IronXL, explore additional functionalities such as formatting cells, creating charts, and managing complex datasets to further enhance your Excel automation capabilities.

Frequently Asked Questions

How do I install IronXL for Python?

You can install IronXL for Python using the pip package manager. Simply run the command: pip install IronXL.

Can I work with Excel files in Python without having Microsoft Office installed?

Yes, you can manipulate Excel files using IronXL in Python without needing to have Microsoft Office installed on your system.

How do I insert an image into an Excel sheet using Python?

To insert an image into an Excel sheet using Python, use IronXL. First, open or create an Excel workbook, then select a worksheet, and use the insert_image method to place the image at the desired location. Finally, save the workbook.

What image formats can be inserted into Excel using IronXL?

IronXL supports various image formats for insertion into Excel, including JPEG, PNG, and BMP.

How do I save an Excel workbook after inserting an image?

After inserting an image into your Excel workbook using IronXL, save the workbook using the save() method with your preferred filename, for example: workbook.save('filename.xlsx').

What should I do if I encounter errors while inserting images into Excel?

If you encounter errors when inserting images, use try-except blocks in your Python code for error handling to manage issues like file not found or unsupported file formats.

How can I specify the cell location for image insertion in an Excel sheet?

When inserting an image using IronXL, specify the cell location using the insert_image method. For example, to insert an image at cell B2, use: worksheet.insert_image('B2', 'image_path').

Is a trial license necessary for using IronXL?

Yes, a trial license is necessary when using IronXL. The tutorial provides steps on how to implement the license to get started.

Can I create new Excel workbooks with IronXL in Python?

Yes, you can create new Excel workbooks using IronXL in Python by instantiating a new workbook object with ironxl.Workbook().

How can IronXL enhance the functionality of Excel for data analysis?

IronXL enhances Excel's functionality in data analysis by allowing automation and integration of additional features like image insertion, which improves the effectiveness of reporting and presentations.

Chaknith Bin
Software Engineer
Chaknith works on IronXL and IronBarcode. He has deep expertise in C# and .NET, helping improve the software and support customers. His insights from user interactions contribute to better products, documentation, and overall experience.
Talk to an Expert Five Star Trust Score Rating

Ready to Get Started?