xlwings检测是否合并单元格,查出位置

1,071 阅读1分钟

利用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()