I am trying to read contents in a table where some cells are vertically merged. When i iterate to the particular row, i get a com exception stating cells are vertically merged so basically cannot proceed. Right now to avoid this i am physically splitting
the merged cells.
Is there a better way? Can i detect tables/rows with merged cells upfront and then split the cells pro-grammatically?
Thanks in advance