在不需要 Pandas 的情況下，使用 Python 讀取 Excel 文件（無需 Interop）

Key Features of IronXL for Python Library

1. Easy Excel File Handling: IronXL simplifies the process of reading, writing, and editing Excel files in Python. Using IronXL, you can manipulate Excel files and save them with ease. It also supports CSV files and XLS files.
2. Multiple Sheet Support: IronXL can easily read and write data across multiple sheets within a single Excel workbook. This is ideal when dealing with Excel files that contain different types of data or reports across various sheets.
3. Read and Write Data:
   • Reading Data: IronXL allows you to access individual cells or entire rows and columns in an Excel file. It supports reading values from all types of cells including text, numbers, and dates.
   • Writing Data: The library supports writing Excel files, whether you need to update existing cells or add new data to the file. It also supports CSV format without importing the CSV module, XLSX files.
4. Cell Formatting: IronXL provides the ability to format Excel cells. You can set text color, font size, borders, and other visual styles directly within the Python script. This is useful for creating reports with specific formatting or when you need to highlight certain data points.
5. Compatibility with Various Excel Formats: IronXL can handle multiple Excel file formats, including .xlsx file format, .xls file format, and .csv file format. This makes it a versatile choice for interacting with Excel files that are shared or exported from various systems.
6. Support for Large Files: IronXL is optimized to handle large Excel files with many rows and columns, making it suitable for data analysis tasks that involve massive datasets.
7. Cross-Platform: While IronXL is built on .NET technologies, it is cross-platform and can be used on Windows, macOS, and Linux through Python.

Step 1: Import the IronXL Library

Import IronXL using the Python package manager for reading Excel spreadsheet data.

pip install ironxl

pip install ironxl

Next, import the necessary libraries from IronXL:

from ironxl import License, WorkBook, WorkSheet

from ironxl import License, WorkBook, WorkSheet

Step 2: Add License Key

IronXL needs a license key. Get your free license from here and place the license at the top of the code.

License.LicenseKey = "Your Key"

License.LicenseKey = "Your Key"

Step 3: Load the Excel File

Load the Excel file using the WorkBook.Load() function. This method returns a Workbook object, which represents the entire Excel file.

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

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

Step 4: Read Excel Files Using IronXL

Now use the workbook object to read the sheets and then read the data in the sheets.

# Iterate over all worksheets
for sheet in workbook.WorkSheets:
    print(f"Sheet Name: {sheet.Name}")
    for row in sheet.Rows:
        # Print each row's values
        print([cell.Value for cell in row]) # excel data

# Iterate over all worksheets
for sheet in workbook.WorkSheets:
    print(f"Sheet Name: {sheet.Name}")
    for row in sheet.Rows:
        # Print each row's values
        print([cell.Value for cell in row]) # excel data

Complete Code

from ironxl import License, WorkBook, WorkSheet

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

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

# Iterate through the sheets in the workbook
for sheet in workbook.WorkSheets:
    # Print the name of each sheet
    print(f"Sheet Name: {sheet.Name}")
    # Iterate through the rows in the current sheet
    for row in sheet.Rows:
        # Print each row's values as a list
        print([cell.Value for cell in row])

from ironxl import License, WorkBook, WorkSheet

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

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

# Iterate through the sheets in the workbook
for sheet in workbook.WorkSheets:
    # Print the name of each sheet
    print(f"Sheet Name: {sheet.Name}")
    # Iterate through the rows in the current sheet
    for row in sheet.Rows:
        # Print each row's values as a list
        print([cell.Value for cell in row])

Code Explanation

The provided code demonstrates how to use IronXL to read data from an Excel file with multiple sheets. Here's an explanation of the code step by step:

1. License Key Setup

The first line of the code sets up the IronXL license by specifying the license key using the License.LicenseKey property. This is required for activating the IronXL library and ensuring it can be used without restrictions.

2. Loading the Excel Workbook

The second line uses the WorkBook.Load() method to load an Excel file (sample.xlsx) into a WorkBook object. This object represents the entire workbook (i.e., the Excel file) and contains all the sheets and data within the file.

3. Iterating Through Sheets

The code then begins a loop through the sheets in the workbook. The WorkBook.WorkSheets property gives access to all the sheets in the loaded workbook. For each sheet, it prints the name of the sheet using sheet.Name. This is useful for identifying which sheet is being processed, especially when working with multiple sheets.

4. Reading and Printing Data from Each Sheet