openpyxl 2.6.x is slower than 2.5.x when loading merged cell
Created originally on Bitbucket by buaabyl (Yuliang Bao)
After upgrade to 2.6.3, I found my script running seconds.
Then I try to read the change log, found that openpyxl 2.6.0 rewrite some merged cell parser or something like this.
I create a small testcase (attachment Book1.xlsx) and test.py, the running log below:
openpyxl 2.5.14
load Book1.xlsx ......
DONE: 0.10938096046447754 seconds
openpyxl 2.6.3
load Book1.xlsx ......
DONE: 2.453608751296997 seconds
test.py
import sys
import os
import re
import getopt
import glob
import time
import openpyxl
from openpyxl import load_workbook
if __name__ == '__main__':
fn = sys.argv[1]
print('openpyxl', openpyxl.__version__)
print('load', fn, '......')
t1 = time.time()
wb = load_workbook(fn)
t2 = time.time()
print('DONE:', t2 - t1, 'seconds')
print()
Attachments: Book1.xlsxtest.py