python用openpyxl操作excel-读取sheet中数据
python用openpyxl操作excel-读取sheet中数据
import logging import com.pro001.log.pro_log_config as pro_log_config from openpyxl import Workbook, load_workbook from openpyxl.styles import Font, Alignment, Side, PatternFill, Border import os import datetime import random import pandas as pd def excel_read_sheet_data(file_path, sheet_name): """ 读取Excel文件指定sheet内容 """ if not os.path.exists(file_path): logger.error(f'文件{file_path}不存在！') return None wb = load_workbook(file_path) if not wb: logger.error(f'文件{file_path}不存在！') return None if sheet_name not in wb.sheetnames: logger.error(f'文件{file_path}中不存在{sheet_name}工作表！') return None # 获取指定sheet的行数和列数 print('-' * 40, 'read_data_rows', '-' * 40) all_rows = [] ws = load_workbook(file_path, data_only=True)[sheet_name] for row in ws.iter_rows(): data_rows = [cell.value for cell in row] all_rows.append(data_rows) print('rows data:', data_rows) print('all rows data:\n', all_rows) return all_rows def main(): """主函数""" excel_read_sheet_data(r'F:\appData\20251207_211304.xlsx', 'TB01') if __name__ == '__main__': print('-' * 60) main()读取结果如下：