read merge cell value

[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.

[larsa]

Hello

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

[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