Find merged cells boundaries

nithinmurali / pygsheets

Google Sheets Python API v4

https://pygsheets.readthedocs.io/en/latest

Other

1.51k stars 220 forks source link

Find merged cells boundaries #508

Closed megastruktur closed 3 years ago

megastruktur commented 3 years ago

Hey there!

Is there any way to find merged cells Addresses in range? The core functionality of the sheet I want to parse is to identify merged ranges and parse them accordingly. However studying the docs and experimenting I couldn't find a way to identify merged cells boundaries if they were merged via Sheets UI.

E.g. I have a range of cells ( A1: C3 ). (B2 : B3) and (C2 : C3) are merged and some data is set there. How can I see whether these ranges are merged or not?

nithinmurali commented 3 years ago

Hi, i have it deployed in staging. please check wks.merged_ranges.