Jimmy
13 ●4 ●7 ●9

3312 ●1 ●8 ●18

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.set_active_sheet('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.

Comments

It works. Thank you soo much.

Jimmy ( 2023-08-06 19:53:48 -0500 )edit

Merge cells in the range (excelpy)

1 answer