The culprit is the non-break space (charcode=\u00a0). I was able to
reproduce the trouble with the following code:
Workbook wb = new SXSSFWorkbook();
Sheet sh = wb.createSheet();
Row row = sh.createRow(0);
row.createCell(0).setCellValue("ALEXANDRE\u00a0MARINHO DE SOUZA");
FileOutputStream out = new FileOutputStream("/temp/test.xlsx");
wb.write(out);
out.close();
The fix is coming soon and will be included in 3.8-beta4.
Cheers,
Yegor
On Wed, Aug 3, 2011 at 1:59 PM, Guilherme Vieira <jguilherm...@gmail.com> wrote:
> Dear Yegor,
>
> Your tip didn't work. So I guessed that there was a non-printable character
> instead of white spaces. That said I tried to encode it with
> URLEncoder.encode("the name goes here","ASCII"); and guess what? The encoded
> name is as below:
>
> ALEXANDRE%3BF+MARINHO+DE+SOUZA
>
> It interesting because I can't remove it with replace all because we have
> non-printable characters. So, I'm trying to find a regular expression that
> matches to these expressions (%3BF and + ,respectively). It would be nice if
> I could find a regular expression that matches to any special non-printable
> characters. So, how do I proceed?
>
> And thanks in advance for your answer as well for your GREAT work in Apache
> POI with the Big Grid Demo approach. It is just wonderful. Can't wait for
> the final release (3.8-beta4).
>
> Best regards,
> José Guilherme Macedo Vieira
>
>
> 2011/8/3 Yegor Kozlov <yegor.koz...@dinom.ru>
>
>> Tweak your report generator and try the following tricks before
>> passing strings to SXSSFCell:
>>
>> (a) string.replaceAll("\\s+", ""); // replace multiple white spaces
>> with a single space
>> (b) string.replace(' ', '_'); // replace white spaces with underscore
>>
>> Does any of (a) and (b) help?
>>
>> My hunch is that the problem is in something else, not in double white
>> spaces. At least, I can't reproduce the problem with the following
>> code snippet:
>>
>> Workbook wb = new SXSSFWorkbook();
>> Sheet sh = wb.createSheet();
>> for(int i = 0; i < 10000; i++) {
>> Row row = sh.createRow(i);
>> row.createCell(0).setCellValue("ALEXANDRE__MARINHO DE SOUZA");
>> row.createCell(1).setCellValue("ALEXANDRE MARINHO DE SOUZA");
>> row.createCell(2).setCellValue("ALEXANDRE MARINHO DE SOUZA");
>> row.createCell(3).setCellValue("ALEXANDRE MARINHO DE SOUZA");
>> }
>>
>> FileOutputStream out = new FileOutputStream("/temp/test.xlsx");
>> wb.write(out);
>> out.close();
>>
>> The generated file is readable and all spaces are there.
>>
>> Yegor
>>
>> On Tue, Aug 2, 2011 at 11:49 PM, Guilherme Vieira
>> <jguilherm...@gmail.com> wrote:
>> > 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.
>> >>
>> >
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
>> For additional commands, e-mail: dev-h...@poi.apache.org
>>
>>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
