How to maintain a cache and do such thing is there any sample code or resource
On Mon, Oct 26, 2015 at 10:37 PM, David North <[email protected]> wrote: > 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] > >
