Openpyxl TypeError: SheetFormatProperties.__init__() получил неожиданный аргумент ключевого слова 'defaultColWidthPt' ⇐ Python

[Anonymous]

Код: Выделить всё

def manytoonebyspire():
import openpyxl
from spire.xls import Workbook
from spire.xls import ExcelVersion
workbook=Workbook()
workbook.LoadFromFile('manysheetbook.xlsx')
workbook1=Workbook()
workbook1.CreateEmptySheets(1)
i=0
for sheet in workbook.Worksheets:
if i==0:
newsheet = workbook1.Worksheets[i]
newsheet.Name = sheet.Name
newsheet.CopyFrom(sheet)
i=i+1
else:
workbook1.CreateEmptySheet()
newsheet = workbook1.Worksheets[i]
newsheet.Name = sheet.Name
newsheet.CopyFrom(sheet)
i=i+1

workbook1.SaveToFile('123.xlsx',ExcelVersion.Version2010)
workbook.Dispose()

wk = openpyxl.load_workbook('123.xlsx')
print(wk.sheetnames[-1])
del wk[wk.sheetnames[-1]]
wk.save('123-1.xlsx')

if __name__=='__main__':
import time
starttime=time.time()
manytoonebyspire()
endtime=time.time()
print(endtime-starttime)

Код: Выделить всё

when wk = openpyxl.load_workbook('123.xlsx')
Prompt error"TypeError: SheetFormatProperties.__init__() got an unexpected keyword argument 'defaultColWidthPt'"

Как мне решить проблему?

Подробнее здесь: https://stackoverflow.com/questions/781 ... -keyword-a