POI読み取りEXCEL実装プログラム_PHPチュートリアル

/*
* 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;

/**
*
* @著者ハンビン
 */
public class ReadExcel {

/**
* @param args はコマンドライン引数です
     */
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 = new FileInputStream(f);
HSSFWorkbook wbs = new HSSFWorkbook(fis);
HSSFSheet childSheet = wbs.getSheetAt(0);
System.out.println("行数:" + childSheet.getLastRowNum());
for(int i =シート.getLastRowNum();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;
}
/* *
*/
private static String getStringCellValue(HSSFCell cell) {
String strCell = "";
switch (cell.getCellType()) {
case HSSFCell.CELL_TYPE_STRING:
str Cell = cell.getStringCellValue();
ブレーク;
ケース 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 = "" ;
ブレーク;
デフォルト:
strCell = "";
ブレーク;
}
if (strCell.equals("") || strCell == null) {
return "";
}
if (cell == null ) {
return "";
}
return strCell;
}
}