Hi guys,
Thanks for the reply. My problem is that cell is defined as text. For
some reason POI considers it as a numeric and adds '.0' to the text of
the cell. If cell is Numeric I can only retrieve context of the cell by
using xlsRow.getCell(colIdx).getNumericCellValue(). I have a mapping in
my application which maps columns in the xls file to the database
fileds.
Let's say DB field defined as varchar(5). File contains 12345. POI adds
'.0' the cell value and I am trying to insert '12345.0' into varchar(5).
So my question is why POI considers text cell with number in it as
numeric(cell format defined as TEXT)
Thank you,
Feliks.
On Thu, Sep 13, 2012 at 3:49 PM, Louis.Masters@log-net.com wrote:
> What is your question exactly? Is it that you want the value returned
> as a string with no decimals or are you encountering an error
> somewhere?
>
>
>
> FELIX BERIG <fberig@optonline.net> wrote on 2012-09-13 01:46:23 PM:
>
>> FELIX BERIG <fberig@optonline.net> 2012-09-13 01:46 PM
>>
>> Please respond to
>> "POI Users List" <user@poi.apache.org>
>>
>> To
>>
>> user@poi.apache.org,
>> cc
>>
>> Subject
>>
>> POI 3.8 Invalid cell type
>>
>>
>> Hi All.
>>
>> I recently upgraded to POI 3.8. I am having issue with cell type when
>> trying to read xls file. The cell is defined as a text. But value in
>> the
>
>> cell is numeric(5678). When I validate the cell type I can see that
>> it is Cell.CELL_TYPE_NUMERIC and the value in the cell is 5678.0
>>
>> Here is the code I have:
>> ...
>> import org.apache.poi.ss.usermodel.Workbook;
>> ....
>> Workbook workbook = null;
>> FileInputStream fileInputStream = new FileInputStream(fileName);
>> if(fileExt.equals("xls"){
>> workbook = new HSSFWorkbook(fileInputStream);
>> }
>> if(fileExt.equals("xlsx"){
>> workbook = new XSSFWorkbook(fileInputStream);
>> }
>> sheet = workbook.getSheetAt(0);
>> xlsRow = sheet.getRow(0);
>>
>> etc....
>>
>>
>> Am I doing something wrong?
>>
>> Thank you,
>> Feliks.
>>
>> ---------------------------------------------------------------------
>> 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
|