一种方法是使用openpyxl模块。
这是一个例子：
from openpyxl import load_workbookwb = load_workbook(filename='data.xlsx', read_only=True)ws = wb['Sheet2']# Read the cell values into a list of listsdata_rows = []for row in ws['A3':'D20']: data_cols = [] for cell in row: data_cols.append(cell.value) data_rows.append(data_cols)# Transform into dataframeimport pandas as pddf = pd.Dataframe(data_rows)
