如何在 Python 中读取具有多个工作表的 Excel 文件

Introduction to IronXL

IronXL for Python is a robust library designed to work with Microsoft Excel files. It allows developers to create, read, and manipulate Excel spreadsheets seamlessly. The main advantages of using IronXL include its ease of use, powerful functionalities, and the fact that it does not require Microsoft Excel to be installed on the server. Developers can read multiple files in an Excel file with ease.

How to Read Excel Files in Python with Multiple Sheets

Step 1: Import the IronXL Library.

Step 2: Add License Key.

Step 3: Load the Excel File.

Step 4: Accessing Sheets in the Workbook.

Why Use IronXL?

IronXL is ideal for various applications such as data analysis, reporting, and automation. Its intuitive API and comprehensive features make it a popular choice among developers. Some of the key features of IronXL include:

• No Dependency on Microsoft Excel: IronXL does not require Microsoft Excel to be installed, making it suitable for server environments.
• Support for Multiple Formats: It supports XLS files, XLSX files, and CSV file formats.
• Cross-Platform Compatibility: IronXL works on Windows, macOS, Linux, Docker, Azure, and AWS.
• Ease of Integration: With a natural and intuitive API, IronXL can be easily integrated into any Python project.

from ironxl import License, WorkBook, WorkSheet

from ironxl import License, WorkBook, WorkSheet

License.LicenseKey = "Your Key"

License.LicenseKey = "Your Key"

workbook = WorkBook.Load('sample.xlsx')

workbook = WorkBook.Load('sample.xlsx')

# Get sheet names from the workbook
sheet_names = workbook.WorkSheetsNames
print("Sheet Names:", sheet_names)

# Iterate through each sheet and read its contents
for sheet in workbook.WorkSheets:
    print(f"Sheet Name: {sheet.Name}")  # Access specific sheet
    for row in sheet.Rows:
        print([cell.Value for cell in row])  # Print each row's cell values

# Get sheet names from the workbook
sheet_names = workbook.WorkSheetsNames
print("Sheet Names:", sheet_names)

# Iterate through each sheet and read its contents
for sheet in workbook.WorkSheets:
    print(f"Sheet Name: {sheet.Name}")  # Access specific sheet
    for row in sheet.Rows:
        print([cell.Value for cell in row])  # Print each row's cell values

Full Code Example

To read all the sheets: Here's the complete code to read an Excel file with multiple sheets:

from ironxl import License, WorkBook, WorkSheet

# Set your IronXL license key
License.LicenseKey = "Your License Key"

# Load the Excel workbook
workbook = WorkBook.Load('sample.xlsx')

# Read Multiple Sheets
for sheet in workbook.WorkSheets:
    print(f"Sheet Name: {sheet.Name}")
    for row in sheet.Rows:
        print([cell.Value for cell in row])  # Print each row values

from ironxl import License, WorkBook, WorkSheet

# Set your IronXL license key
License.LicenseKey = "Your License Key"

# Load the Excel workbook
workbook = WorkBook.Load('sample.xlsx')

# Read Multiple Sheets
for sheet in workbook.WorkSheets:
    print(f"Sheet Name: {sheet.Name}")
    for row in sheet.Rows:
        print([cell.Value for cell in row])  # Print each row values

IronXL License (Trial Available)

IronXL works on a valid license file attached to the code. Users can easily get a trial license from the license page.

To use the license, place the license somewhere at the beginning in your code as shown below before using IronXL functionalities.

from ironxl import License

License.LicenseKey = "Your License Key"

from ironxl import License

License.LicenseKey = "Your License Key"

Conclusion

IronXL for Python is a powerful and efficient tool for handling Excel files with multiple sheets. Whether you're reading data, formatting cells, or handling larger files, IronXL simplifies the process, providing a clean and intuitive API. By following the steps above, you can quickly load and manipulate Excel files with multiple sheets in Python. IronXL stands out as an excellent choice for developers and data scientists who need to work with Excel in a seamless and effective way.

For more information and examples, you can refer to the IronXL Documentation.