Page 1 of 1

read merge cell value

Posted: Mon Jan 16, 2017 11:05 am
by MaxChan
I have problem on read the merge cell value.
Merge cell (A1,B1) and assigned a value to it.I can get value using XLS[0].Asstring[0,0] but not XLS[0].Asstring[1,0]
since cell [1,0] is already merged.

Is there any way to read merged cell value?

thanks.

Re: read merge cell value

Posted: Wed Jan 18, 2017 10:55 am
by larsa
Hello

The value of a merged cell is always in the top-left corner.

Re: read merge cell value

Posted: Tue Sep 19, 2023 8:51 am
by dxs405
Hello,
I have a similar question, if i have a merged cells[A1,A2], how to know the cells[A2] is merged or not?

Thanks!
Daniel