Home >Backend Development >Python Tutorial >How to read excel data in python

How to read excel data in python

下次还敢
下次还敢Original
2024-04-11 02:14:561120browse

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 read excel data in python

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

import openpyxl

Step 3: Open the workbook

workbook = openpyxl.load_workbook('example.xlsx')

Step 4: Select the worksheet

worksheet = workbook.active

Step 5: Read the cell value

value = worksheet.cell(row=1, column=1).value

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

for row in worksheet.rows:
    for cell in row:
        value = cell.value

Step 6: Read the value of a specific range

values = worksheet.range('A1:C5').value

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

Step 7: Read the formula result

value = worksheet.cell(row=1, column=1).value

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

Example:

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)

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn