How to read excel data in python

下次还敢
Release: 2024-04-11 02:14:56
Original
934 people have browsed it

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

pip install openpyxl
Copy after login

Step 2: Import the library

import openpyxl
Copy after login

Step 3: Open the workbook

workbook = openpyxl.load_workbook('example.xlsx')
Copy after login

Step 4: Select the worksheet

worksheet = workbook.active
Copy after login

Step 5: Read the cell value

value = worksheet.cell(row=1, column=1).value
Copy after login
Copy after login

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
Copy after login

Step 6: Read the value of a specific range

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

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
Copy after login
Copy after login

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)
Copy after login

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!

Related labels:
source:php.cn
Statement of this Website
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
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!