That's correct. You need to iterate through each merged region in turn and see if your cell is in it. Unfortunately the way Excel stores the information means you can't easily get from a cell to "is this part of a merged region?". If you're reading a spreadsheet in and not altering it, you might choose to build up and maintain a cache to avoid having to loop every time you ask the question about a cell.
David On 26/10/15 16:21, Blake Watson wrote: > I haven't done this but it seems to me that you would get the merged > regions from the sheet (getMergedRegion) and then check each one to see if > the cell was in that region. > > On Mon, Oct 26, 2015 at 3:54 AM, Rohit Cha <[email protected]> wrote: > >> Hi, >> >> I am having an Excel-File containing both normal cells and Merged >> Cells I am working on getting data of the Excel File,so i want to know if >> there is any feature such that on giving a specific cell that will tell me >> weather the cell is a merged cell or not and if the cell is a merged cell >> give me the value of first row,colon of the cell(i mean merged cell value) >> >> ThankYou >> > > -- David North, Technical Lead, CoreFiling Limited http://www.corefiling.com Phone: +44-1865-203192 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
