Want to know if a feature is available or not

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

Re: Want to know if a feature is available or not

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 wrote: > Hi, > > I am having an Excel-File

Re: Want to know if a feature is available or not

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