| 代碼如下 |
複製代碼 |
/*
* 使用POI讀取EXCEL檔案
*/
import java.io.File;
import java.io.FileInputStream;
import java.util.ArrayList;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
/**
*
* @author Hanbin
*/
public class ReadExcel {
/**
* @param args the command line arguments
*/
public static void main(String[] args)throws Exception {
read("d:demo.xls");
}
public static ArrayList read(String fileName){
ArrayList list = new ArrayList();
String sql = "";
try{
File f = new File(fileName);
FileInputStream fis = new FileInputStream(f);
HSSFWorkbook wbs = new HSSFWorkbook(fis);
HSSFSheet childSheet = wbs.getSheetAt(0);
System.out.println("行數:" + childSheet.getLastRowNum());
for(int i = 4;i HSSFRow row = childSheet.getRow(i);
System.out.println("列數:" + row.getPhysicalNumberOfCells());
if(null != row){
for(int k=1;k HSSFCell cell;
cell = row.getCell((short)k);
// System.out.print(getStringCellValue(cell) + "t");
list.add(getStringCellValue(cell) + "t");
}
}
}
}catch(Exception e){
e.printStackTrace();
}
return list;
}
/**
* 擷取儲存格資料內容為字串類型的資料
*
* @param cell Excel儲存格
* @return String 儲存格資料內容
*/
private static String getStringCellValue(HSSFCell cell) {
String strCell = "";
switch (cell.getCellType()) {
case HSSFCell.CELL_TYPE_STRING:
strCell = cell.getStringCellValue();
break;
case HSSFCell.CELL_TYPE_NUMERIC:
strCell = String.valueOf(cell.getNumericCellValue());
break;
case HSSFCell.CELL_TYPE_BOOLEAN:
strCell = String.valueOf(cell.getBooleanCellValue());
break;
case HSSFCell.CELL_TYPE_BLANK:
strCell = "";
break;
default:
strCell = "";
break;
}
if (strCell.equals("") || strCell == null) {
return "";
}
if (cell == null) {
return "";
}
return strCell;
}
} |
http://www.bkjia.com/PHPjc/444639.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/444639.htmlTechArticle代碼如下 複製代碼 /* * 使用POI讀取EXCEL檔案 */ import java.io.File; import java.io.FileInputStream; import java.util.ArrayList; import org.apache.poi.hssf.usermodel.H...
