如何使用 Python 在 Excel 中插入圖片

步驟 1：安裝 IronXL for Python 套件。

請確保您已建立擴展名為 .py 的 Python 檔案。 現在使用 pip 安裝 IronXL 軟體套件：

pip install IronXL

pip install IronXL

步驟 2：建立或開啟 Excel 工作簿。

使用 IronXL 建立 Excel 檔案或開啟現有 Excel 檔案。

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')

步驟 3：選擇要插入影像的工作表。

# 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

步驟 4：將影像插入指定位置。

# 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)

步驟 5：儲存工作簿。

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

# Save the workbook with the desired filename
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')

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')

說明程式碼

1.建立/開啟工作簿：您可以使用ironxl.Workbook()函數建立新工作簿或開啟現有工作簿。 對於現有的 Excel 文件，請確保提供工作簿的正確文件路徑。

2.選擇工作表：使用add_worksheet()新增工作表，或使用get_worksheet()存取現有工作表。

3.插入影像：使用insert_image()方法插入影像。 您需要指定要插入影像的儲存格和影像檔案路徑/屬性。

4.儲存工作簿：使用save()方法以所需的檔案名稱儲存工作簿。

圖片尺寸和格式

插入圖片時，請考慮圖片的大小和寬高比，使其能夠很好地適應單元格。 請事先調整圖片大小，或使用其他方法插入後調整其尺寸。

錯誤處理

實現錯誤處理機制，以應對諸如找不到文件、不支援的文件格式或 Excel 文件本身存在問題等情況。 使用 try-except 程式碼區塊有助於優雅地處理異常。

依賴關係和局限性

IronXL功能強大，但請注意其依賴項和許可協議。 請務必遵守許可條款，並注意免費版本中的任何限制。