原表格内容
from openpyxl import load_workbook
src_file = 'excle_test.xlsx'
def list_excle_out(src_file,lie,hang=1):
'''
:param src_file:Excel路径
:param lie: 一共多少列，具体列数
:param hang: 需要第几行开始的内容
:return: 列表：
'''
wb = load_workbook(filename=src_file)
my_sheet = wb['000']
list_value_all = []
list_value_one = []
for row in my_sheet.rows:
for cell in row:
list_value_all.append(cell.value)
for i in range(0,len(list_value_all),lie):
list_value_one.append(list_value_all[i:i+lie])
return list_value_one[hang-1:]
print(list_excle_out(src_file,9,1))
输出：[[1, 2, 3, 4, 5, 6, 7, 8, 9], [2, 3, 4, 5, 6, 7, 8, 9, 10], [3, 4, 5, 6, 7, 8, 9, 10, 11]]
print(list_excle_out(src_file,9,2))
输出：[[2, 3, 4, 5, 6, 7, 8, 9, 10], [3, 4, 5, 6, 7, 8, 9, 10, 11]]
