Just to add an answer: the problem was that on the 12 or 13th insert the record that would come would be some how too big for excel to digest. usually if the cell value is greater than 32,000 chars it will throw the exception that value is too big but in this case it didnt, may be that was not the issue. but what i did was i wrote each insert into its own respective file and i got all the responses and even this one too, but the file was too big while the rest of my files were like under 100 KB this one was more than 300 KB so something huge was in there and the file didnt even open right. and showed me an empty file even tho the size was 300 KB. so when this data was inserted to the excel file may be POI didnt manage to write it completely and thats why it said that so much so bytes still needed to be written. hence the next inserts failed after that.
So i just have to see what is in the data thats causing this. other wise this is solved. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/exception-on-HSSFWorkbook-creation-tp5162898p5163763.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]
