使用openpyxl读取excel遇到几个问题:

1. 唯读模式非常慢

from openpyxl import load_workbook
#wb = load_workbook(filename, read_only=True) 不要用, 很可怕
wb = load_workbook(filename)

2. 在储存前就终止程式的话, excel档会毁损, 建议load_workbook 先作备一份, 每次Save() 另存到备份档, 完成时再存到原档, 再删除备份备

import shutil
import os
from openpyxl import load_workbook

filename2 = filename.replace('.x', '2.x').replace('.X', '2.X')
shutil.copy(filename, filename2)
wb = load_workbook(filename)
ws = wb.active
for i in range(startrow,endrow+1):#excel行号
    if x % 10 == 0:
      wb.save(filename2)
      print('....SAVE....')
	#to do
wb.save(filename)
wb.close()
os.remove(filename2)

Taiwan is a country. 台湾是我的国家