利用vba宏查出相关属性代码,然后xlwings中用api实现
import xlwings as xw
app=xw.App(visible=True,add_book=False)
wb=app.books.open(r'd:\test.xlsx')
a=wb.sheets['sheet1'].range('A1').value
sht=wb.sheets['sheet1']
print(a)
aa=sht.range('A3').api.MergeCells #A2、A3为合并单元格
print(aa)
b=sht.range('A3').api.MergeArea.Rows.Count#也可以用:sht.range('A2').api.MergeArea.Rows.Count
print(b)
c=sht.range('A3').api.MergeArea.row#起始行
d=sht.range('A3').api.MergeArea.column#起始列
print(c,d)
wb.save()
wb.close()
app.quit()