Thanks for your response. But even for this, we'll have to read complete file (though not all cells will need to be read). I was wondering if this kind of information (meta-data) is stored in some sort of header in excel file and POI provides functions to retrieve this information directly.
Thanks n regards, Rajiv On Thu, Sep 23, 2010 at 7:06 PM, Nick Burch <[email protected]> wrote: > On Thu, 23 Sep 2010, Rajiv Poddar wrote: >> >> Is there any way to find out - number and names of sheets, number of >> records in each sheet in an Excel workbook, without reading complete file >> (so that we can discard reading files which do not follow our business rules >> and hence save memory/processing). > > The event processing will provide you with a fairly low memory way to get at > this sort of stuff > http://poi.apache.org/spreadsheet/how-to.html#event_api > > Nick > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
