You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Mester József <me...@gmail.com> on 2015/03/25 09:31:57 UTC
Reading XLSX cell content
Hello POI users
I am new at this forum and I can't search the archive .
1, How can I search in the list archive
2,
I have a xlsx with large amount of formatted text data in cells.
The text contains enumerations . When I read the cell java chaned
enumeration's character into question mark.
Is it a character encoding problem? Or POI problem?
You can see:
https://www.dropbox.com/s/qsad6n7tv3ty2r1/nvleiras.xlsx?dl=0
Mester
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Reading XLSX cell content
Posted by Nick Burch <ap...@gagravarr.org>.
On Thu, 26 Mar 2015, Mester József wrote:
> I read cell's very simple way :
>
> String currentCellData =currentRow.getCell(data).toString()
That really isn't recommended. If you want a string of "what Excel shows
the user for a cell", use DataFormatter
The toString method is really only there for debugging and logging, not
production use for displaying to users etc
Nick
Re: Reading XLSX cell content
Posted by Mester József <me...@gmail.com>.
Thank you Dominik.
I don't find information about this problem.
I read cell's very simple way :
String currentCellData =currentRow.getCell(data).toString()
Joe
2015.03.25. 21:00 keltezéssel, Dominik Stadler írta:
> Hi,
>
> 1. The mailing lists have a gmame mirror, which allows searching, e.g.
> http://news.gmane.org/gmane.comp.jakarta.poi.user and
> http://news.gmane.org/gmane.comp.jakarta.poi.devel, also google can be
> used via a search like
> "site:http://mail-archives.apache.org/mod_mbox/poi-user/
> <search-term>"
>
>
> 2. It likely depends on how you read the contents. Can you show a bit
> of your code where you use POI?
>
> Thanks... Dominik.
>
>
> On Wed, Mar 25, 2015 at 9:31 AM, Mester József <me...@gmail.com> wrote:
>> Hello POI users
>>
>> I am new at this forum and I can't search the archive .
>> 1, How can I search in the list archive
>> 2,
>> I have a xlsx with large amount of formatted text data in cells.
>> The text contains enumerations . When I read the cell java chaned
>> enumeration's character into question mark.
>>
>> Is it a character encoding problem? Or POI problem?
>>
>> You can see:
>> https://www.dropbox.com/s/qsad6n7tv3ty2r1/nvleiras.xlsx?dl=0
>>
>> Mester
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Reading XLSX cell content
Posted by Dominik Stadler <do...@gmx.at>.
Hi,
1. The mailing lists have a gmame mirror, which allows searching, e.g.
http://news.gmane.org/gmane.comp.jakarta.poi.user and
http://news.gmane.org/gmane.comp.jakarta.poi.devel, also google can be
used via a search like
"site:http://mail-archives.apache.org/mod_mbox/poi-user/
<search-term>"
2. It likely depends on how you read the contents. Can you show a bit
of your code where you use POI?
Thanks... Dominik.
On Wed, Mar 25, 2015 at 9:31 AM, Mester József <me...@gmail.com> wrote:
> Hello POI users
>
> I am new at this forum and I can't search the archive .
> 1, How can I search in the list archive
> 2,
> I have a xlsx with large amount of formatted text data in cells.
> The text contains enumerations . When I read the cell java chaned
> enumeration's character into question mark.
>
> Is it a character encoding problem? Or POI problem?
>
> You can see:
> https://www.dropbox.com/s/qsad6n7tv3ty2r1/nvleiras.xlsx?dl=0
>
> Mester
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org