....and I should have said that you can do something similar with cells, try to get the cell from the row, check what the call returns and if it is null lazilly create the cell. Just to be a PTBO (a Professor of The B&**%in Obvious (Copyright Bob Crowe 1996)) if that solves your problems, there is no need to post your code here.
Yours Mark B Andrew Feller-2 wrote: > > Hello, > > > > I am using POI 3.0.1 to dynamically populate an Excel spreadsheet, however > I continually encounter NullPointerException whenever I try to retrieve or > create rows at the end of the document. Apparently, it doesn’t see any > more rows “defined” and thus returns NPE. > > > > QUESTION: Is it possible to tell POI to continually retrieve / create rows > regardless of being touched (formatting, borders, etc)? > > > > Thank you, > > > > Andrew R. Feller > Software Engineer > TraceSecurity, Inc. > 5615 Corporate Blvd Ste 200A > Baton Rouge, LA 70808 > Phone: (225) 612-2121 X 31004 > Fax: (225) 612-2115 > > > > -- View this message in context: http://old.nabble.com/NPE-while-retrieving---creating-rows-within-spreadsheet-tp26784101p26790989.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
