通过openpyxl获取excel最大的行数，然后对最大行数分为3块，skip, nrows参数 使用joblib库读取，

通过openpyxl获取Excel文件的最大行数可以使用worksheet对象的"max_row"属性。示例代码如下：

from openpyxl import load_workbook

# Load the workbook
wb = load_workbook("file.xlsx")

# Select the active worksheet
ws = wb.active

# Get the maximum row number
max_row = ws.max_row
print(max_row)

然后可以使用下面的代码来分成3块读取

from joblib import Parallel, delayed

# Define the number of rows per chunk
chunk_size = max_row // 3

# Get the ranges for each chunk
ranges = [(0, chunk_size), (chunk_size, chunk_size*2), (chunk_size*2, max_row)]

# Read in each chunk in parallel
results = Parallel(n_jobs=-1)(delayed(read_data)(start, end) for start, end in ranges)

这里read_data 函数里面就是你定义读取excel 的语句

其中 skip， nrows 参数可以在delayed函数中使用.