read merge cell value

Questions and answers on how to use XLSSpreadSheet.
Post Reply
MaxChan
Posts: 19
Joined: Sat Sep 03, 2016 6:38 am

read merge cell value

Post 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.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: read merge cell value

Post by larsa »

Hello

The value of a merged cell is always in the top-left corner.
Lars Arvidsson, Axolot Data
dxs405
Posts: 1
Joined: Tue Sep 19, 2023 8:48 am

Re: read merge cell value

Post 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
Post Reply