excel里的格字的内容是“47643300”,使用POI读出来变成了“24.76433E7”
咋让他原汁原味的读出来啊 public static void main(String[] args) throws Exception {
HSSFWorkbook excel = new HSSFWorkbook(new POIFSFileSystem(
new FileInputStream("D:\\longgang.xls")));
HSSFSheet sheet = excel.getSheet("sheet1");
HSSFRow row = sheet.getRow(sheet.getLastRowNum());
for (int i = row.getFirstCellNum(); i <= row.getLastCellNum(); i++) {
HSSFCell cell = row.getCell(i);
CellReference cellRef = new CellReference(i, cell.getColumnIndex());
System.out.print(cellRef.formatAsString());
switch (cell.getCellType()) {
case Cell.CELL_TYPE_STRING:
System.out.println(cell.getRichStringCellValue().getString());
break;
case Cell.CELL_TYPE_NUMERIC:
if (DateUtil.isCellDateFormatted(cell)) {
System.out.println(cell.getDateCellValue());
} else {
System.out.println(cell.getNumericCellValue());
}
break;
case Cell.CELL_TYPE_BOOLEAN:
System.out.println(cell.getBooleanCellValue());
break;
case Cell.CELL_TYPE_FORMULA:
System.out.println(cell.getCellFormula());
break;
default:
System.out.println();
}
}
}
咋让他原汁原味的读出来啊 public static void main(String[] args) throws Exception {
HSSFWorkbook excel = new HSSFWorkbook(new POIFSFileSystem(
new FileInputStream("D:\\longgang.xls")));
HSSFSheet sheet = excel.getSheet("sheet1");
HSSFRow row = sheet.getRow(sheet.getLastRowNum());
for (int i = row.getFirstCellNum(); i <= row.getLastCellNum(); i++) {
HSSFCell cell = row.getCell(i);
CellReference cellRef = new CellReference(i, cell.getColumnIndex());
System.out.print(cellRef.formatAsString());
switch (cell.getCellType()) {
case Cell.CELL_TYPE_STRING:
System.out.println(cell.getRichStringCellValue().getString());
break;
case Cell.CELL_TYPE_NUMERIC:
if (DateUtil.isCellDateFormatted(cell)) {
System.out.println(cell.getDateCellValue());
} else {
System.out.println(cell.getNumericCellValue());
}
break;
case Cell.CELL_TYPE_BOOLEAN:
System.out.println(cell.getBooleanCellValue());
break;
case Cell.CELL_TYPE_FORMULA:
System.out.println(cell.getCellFormula());
break;
default:
System.out.println();
}
}
}
解决方案 »
- java.lang.IllegalArgumentException: Files' name is invalid or does not exist
- Action 如何访问同一网段内 不同机器的web工程
- 严重: ORA-02289: 序列不存在。急!!!在线等...
- weblogic配置双数据源问题
- struts2 中隐藏表格列问题
- 请问在hibernate 里怎样进行实体参数查询呢?
- 如何让jboss只记录当天日志 在线等回复
- struts-config.xml
- 请教关于XML验证的问题
- 救!来个私有方法厉害的大佬,求完整版,网上都是残缺的
- struts2有exceptionp-mapping映射,谁用过啊?
- struts2 token 问题
df.format(cell.getNumericCellValue());