poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Guilherme Vieira <jguilherm...@gmail.com>
Subject Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Date Tue, 02 Aug 2011 19:49:12 GMT
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 <jguilhermemv@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-237524@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.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message