Python 用於 Excel 文件的包（不使用 Interop）

IronXL - The Python Excel Library

IronXL for Python is a versatile library that simplifies Excel Spreadsheet operations within Python projects. Its intuitive API allows developers to perform a wide range of tasks, from creating and editing Excel worksheets to extracting and analyzing data.

Here are some key features of IronXL.

Prerequisites

Before moving forward, ensure you have the following prerequisites installed on your system:

1. Python: Install Python from the official website (https://www.python.org/downloads/) if you haven't already.
2. PyCharm: Download and install PyCharm, a popular Python IDE, to streamline your development workflow.

3. IronXL Library: Install IronXL using PIP, Python's package manager, by running the following command in your terminal or command prompt:

   pip install IronXL

   pip install IronXL

   SHELL
4. .NET 6.0 SDK: IronXL for Python is built upon the IronXL .NET library, particularly relying on .NET 6.0. To effectively utilize IronXL for Python, it's necessary to have the .NET 6.0 Software Development Kit (SDK) installed on your machine. This SDK provides the necessary components for running IronXL for Python without any errors. You can download it from here: https://dotnet.microsoft.com/en-us/download/dotnet/6.0.

Create Python Project in PyCharm

1. Launch PyCharm and create a new Python project by selecting "New Project".

2. Choose a name and location for your project, then click "Create."

3. Once your project is created, you can start writing Python code to interact with Excel files using IronXL.

Install IronXL using PIP

In your PyCharm project, open a terminal window and execute the following command to install IronXL:

pip install IronXL

pip install IronXL

This will download and install the IronXL library, allowing you to use its functionalities in your Python code.

Create Excel File

Now, let's create a new Excel file using IronXL. Below is a sample Python code snippet to create an Excel file:

from ironxl import *

# Create a new Excel file (workbook)
workbook = WorkBook.Create()

# Add a worksheet named "Sheet1"
worksheet = workbook.CreateWorkSheet("Sheet1")

# Write data to specific cells in the worksheet
worksheet["A1"].Value = "Hello"
worksheet["B1"].Value = "World"

# Save the workbook as "example.xlsx"
workbook.SaveAs("example.xlsx")

from ironxl import *

# Create a new Excel file (workbook)
workbook = WorkBook.Create()

# Add a worksheet named "Sheet1"
worksheet = workbook.CreateWorkSheet("Sheet1")

# Write data to specific cells in the worksheet
worksheet["A1"].Value = "Hello"
worksheet["B1"].Value = "World"

# Save the workbook as "example.xlsx"
workbook.SaveAs("example.xlsx")

This code creates a new Excel workbook with a single worksheet named "Sheet1" and writes "Hello" and "World" to cells A1 and B1, respectively. Finally, it saves the workbook as "example.xlsx" in the current directory.

The above screenshot shows how efficiently we can create and write Excel files from scratch in Python using the IronXL for Python module.

Read Excel Files

To read data from an existing Excel file, you can use IronXL's WorkBook.Load() method. Here's a simple example of how to read Excel files:

from ironxl import WorkBook

# Load an existing Excel workbook from the file system
workbook = WorkBook.Load("example.xlsx")

# Access the first worksheet in the workbook
worksheet = workbook.sheets[0]

# Read data from cell A1 in the worksheet
data = worksheet["A1"].value

# Print the data retrieved from cell A1
print(data)  # Output: Hello

from ironxl import WorkBook

# Load an existing Excel workbook from the file system
workbook = WorkBook.Load("example.xlsx")

# Access the first worksheet in the workbook
worksheet = workbook.sheets[0]

# Read data from cell A1 in the worksheet
data = worksheet["A1"].value

# Print the data retrieved from cell A1
print(data)  # Output: Hello

This code loads the "example.xlsx" file, accesses the first worksheet, and reads the value from cell A1, which is then printed to the console.

For more detailed information on IronXL and its capabilities, please visit the documentation and code examples page.

Conclusion

IronXL for Python is a versatile library that simplifies Excel file manipulation in Python projects. By following this tutorial, we've learned how to create, read, and manipulate Excel files using IronXL. With its intuitive API and powerful features, IronXL opens up endless possibilities for working with Excel data in Python.

Start incorporating IronXL into your Python projects with its free trial for commercial use today and unleash the full potential of Excel manipulation with ease and efficiency.