java读取excel数字类型_POI读取Excel 各种特殊数字和类型的转换。

Java代码packagecom.golden.test;importjava.io.File;importjava.io.FileInputStream;importorg.apache.poi.hssf.usermodel.HSSFCell;importorg.apache.poi.hssf.usermodel.HSSFRow;importorg.apache.poi.hssf.usermodel.HSSFSheet;importorg.apache.poi.hssf.usermodel.HSSFWorkbook;/***

*@author崔素强

**/

public classPoiReadXls2 {public static voidmain(String[] args) {

File f= new File("c:\\a.xls");try{

FileInputStream is= newFileInputStream(f);

HSSFWorkbook wbs= newHSSFWorkbook(is);

HSSFSheet childSheet= wbs.getSheetAt(0);//System.out.println(childSheet.getPhysicalNumberOfRows());

System.out.println("有行数" +childSheet.getLastRowNum());for (int j = 0; j < childSheet.getLastRowNum(); j++) {

HSSFRow row=childSheet.getRow(j);//System.out.println(row.getPhysicalNumberOfCells());//System.out.println("有列数" +