So, I've searched column by column in the problematic line in order to identify the problem. The problem is quite weird. It's a string column in the database. This column stores people names.
In my problem the name is: ALEXANDRE__MARINHO DE SOUZA Of course, without the underline character. Instead it is a whitespace character. So, when with double whitespace character the file is corrupted. And when I manually remove the one whitespace in the IDE, the file is also corrupted. But when I change the whole name manually in the IDE, setting the value to ALEXANDRE_MARINHO DE SOUZA, it works. It's strange. I don't know why SXSSF is not accepting two whitespaces. Anyone have a clue? 2011/8/2 jguilhermemv <jguilherm...@gmail.com> > I tried without merged region and it didn't work. So, I noticed that there > is a line in the file which present the error. It's the line (2451) and > until the line 2450 everything works great. But for some reason when it > reach the line 2450 it just doesn't work. I checked if the was any null > values, but there wasn't. The writing routine is right, otherwise it > wouldn't write until the line 2450. > > What can I do now? > > Best regards. > José Guilherme Macedo Vieira > > > 2011/8/2 Nick Burch-11 [via Apache POI] < > ml-node+4658878-753894702-237...@n5.nabble.com> > > > On Tue, 2 Aug 2011, jguilhermemv wrote: > > > Regarding the file, it makes use of some CellStyles and Merged Regions. > > > > Try without them, and see if that fixes it. You need to narrow your > > problem down before you can figure out what to correct. Try to identify > > the simplest file that fails, and the most complex one that works, the > gap > > there is your issue > > > > Nick > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [hidden email]< > http://user/SendEmail.jtp?type=node&node=4658878&i=0> > > For additional commands, e-mail: [hidden email]< > http://user/SendEmail.jtp?type=node&node=4658878&i=1> > > > > > > > > ------------------------------ > > If you reply to this email, your message will be added to the discussion > > below: > > > > > http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4658878.html > > To unsubscribe from Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content, > click > > here< > http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658852&code=amd1aWxoZXJtZW12QGdtYWlsLmNvbXw0NjU4ODUyfDg3MzU2ODc4NA== > >. > > > > > > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4659737.html > Sent from the POI - Dev mailing list archive at Nabble.com. >
