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

pip install openpyxl

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!