如何在apache POI中阅读excel文件的精确单元格内容 [英] how to read exact cell content of excel file in apache POI
问题描述
但是什么我想要的是获取每个单元格的确切字符串值。
我的代码是这样的:
cell.setCellType(Cell.CELL_TYPE_STRING);
String str = cell.getStringCellValue();
不需要显式格式化, apache-poi
提供 DataFormatter
类作为实用程序,以利用Excel上出现的内容的格式。您也可以选择自定义格式,一个简单的例子是(单元格参考您的 XSSFCell
对象):
System.out.println(new DataFormatter()。formatCellValue(cell));
Excel表格如下所示:
img src =https://i.stack.imgur.com/iCsoL.pngalt =enter image description here>
使用 DataFormatter
(上面的sop语句)打印:
50%
$ 1,200
12/21/14
您正常格式化的打印方式:
0.5
1200.0
2014年12月21日
when I read a content of cell for e.g. if it is in date format it casts into some another value like 12/31/2099 -> 46052 and $50.00 -> 50 and 50.00% -> 0.5.
But what I want is to get the exact string value for every cell.
My Code is like this:
cell.setCellType(Cell.CELL_TYPE_STRING);
String str = cell.getStringCellValue();
No need for explicit formatting, apache-poi
provides for DataFormatter
class as utility to leverage the format of the content as it appears on the excel. You can choose custom formats too, a simple example would be (cell is reference to your XSSFCell
object):
System.out.println(new DataFormatter().formatCellValue(cell));
Excel sheet looks like:
Using DataFormatter
(sop statement above) prints:
50%
$ 1,200
12/21/14
Where your normal formatting would print:
0.5
1200.0
21-Dec-2014
这篇关于如何在apache POI中阅读excel文件的精确单元格内容的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!