How to read excel data in python

How to use the Python openpyxl library to read Excel data: install the openpyxl import library, open the workbook, select the worksheet, read the cell value, read the value of a specific area, read the formula result

How to use Python to read Excel data

Python provides a variety of built-in modules and third-party libraries to read Excel data. Here's how to read Excel data using one of the most common methods, the openpyxl library:

Step 1: Install openpyxl

<code>pip install openpyxl</code>

Step 2: Import the library

<code class="python">import openpyxl</code>

Step 3: Open the workbook

<code class="python">workbook = openpyxl.load_workbook('example.xlsx')</code>

Step 4: Select the worksheet

<code class="python">worksheet = workbook.active</code>

Step 5: Read the cell value

<code class="python">value = worksheet.cell(row=1, column=1).value</code>

This method will return the value of cell A1. To read the cell value of the entire worksheet, you can use the following loop:

<code class="python">for row in worksheet.rows:
    for cell in row:
        value = cell.value</code>

Step 6: Read the value of a specific range

<code class="python">values = worksheet.range('A1:C5').value</code>

This method will return A1 to the value of the cell in the range C5.

Step 7: Read the formula result

<code class="python">value = worksheet.cell(row=1, column=1).value</code>

This method will return the result of the formula in cell A1, not the formula itself.

Example:

<code class="python">import openpyxl

# 打开工作簿
workbook = openpyxl.load_workbook('example.xlsx')

# 选择工作表
worksheet = workbook.active

# 读取特定区域的值
values = worksheet.range('A1:C5').value

# 逐行和逐列打印值
for row in values:
    for cell in row:
        print(cell)</code>

The above is the detailed content of How to read excel data in python. For more information, please follow other related articles on the PHP Chinese website!