Revision history [back]

I've tried to merge cells in the range in excel using python (PSS/E,python ,API). But It shows errors.

There's something I should import? or my code has something wrong? Thanks for reading my question.

My code：

x1=excelpy.workbook(r'D:\pythontest\origin','test1')

x1.show()

x1.setactivesheet('test_1')

x1.merge(('b1','d1'),'test_1')

Error：

Traceback (most recent call last):

File "D:\pythontest\automationtest_14.py", line 12, in <module>

x1.merge(('b1','d1'),'test_1')

File ".\excelpy.py", line 621, in merge

File ".\excelpy.py", line 1185, in activerange

ValueError: need more than 2 values to unpack

Thanks for reading my question.

I've tried to merge cells in the range in excel using python (PSS/E,python ,API). But It shows errors.

There's something I should import? or my code has something wrong? Thanks for reading my question.

My code：

x1=excelpy.workbook(r'D:\python_test\origin','test_1')
 x1.show()
 
x1.show()x1.set_active_sheet('test_1')
  
x1.setactivesheet('test_1')
 
x1.merge(('b1','d1'),'test_1')x1.merge(('b1','d1'),'test_1')

Error：

Traceback (most recent call last):

File "D:\pythontest\automationtest_14.py", line 12, in <module>

x1.merge(('b1','d1'),'test_1')

File ".\excelpy.py", line 621, in merge

File ".\excelpy.py", line 1185, in activerange

ValueError: need more than 2 values to unpack

Thanks for reading my question.