pickle 保存 python对象

import openpyxl
import pickle
import time

'''
target = r'c:/users/administrator/desktop/bill.xlsx'

wb = openpyxl.load_workbook(target)
sh = wb['空表']

nrows = 38 #sh.max_row
ncols = 24 #sh.max_column



with open(r'c:/users/administrator/desktop/excel.bin','ab') as buffer:
    for r in range(nrows):
        for c in range(ncols):
            obj = pickle.dumps(sh.cell(row = r+1,column=c+1))
            buffer.write(obj)
            
'''

wb = openpyxl.Workbook()
sh = wb.active

cells = []

start_time = time.time()
with open(r'c:/users/administrator/desktop/excel.bin','rb') as buffer:
    while True:
        try:
            obj = pickle.load(buffer)
            cells.append(obj)
        except:
            break
end_time = time.time()
print(end_time-start_time)
# 15s