excelprocess.java

java 读取并处理Excel 的javaBean.

/*
 * Created on 2008/03/03
 * 使用poi-bin-3.0-FINAL-20070503.zip中三个jar包
 * 读取Excel文件内容
 * @author zhangjingwei
 */
package com.hhsoft.tools;

import java.io.*;
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 ExcelProcess
{
    //设置被读取的EXCEL的位置
    public static String fileToBeRead = "C:/1审监庭2.xls";

    public static void main(String args[])
    {
        readExcel(fileToBeRead);

    }
	public static String readExcel(String filename)
	 {
	  StringBuffer text = new StringBuffer("");
	  String temp = "";
	  try{
	   
		   int sheetnum=0;
		   
		   HSSFSheet sheet = null;
		   
		   HSSFRow row=null;
		   
		   HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(filename));
		 //  for (sheetnum=0;sheetnum<workbook.getNumberOfSheets();sheetnum++)
		 //  {
			    sheet = workbook.getSheetAt(sheetnum);
			    
			    int lastrow=0;
			    
			    int rownum=0;
			    
			    lastrow=sheet.getLastRowNum();
			    
			    for (rownum=0;rownum<lastrow;rownum++)
			    {
				     row = sheet.getRow(rownum);
				     if (row!=null)
				     {
					      short firstcell=row.getFirstCellNum();
					      short lastcell=row.getLastCellNum();
					      short cellnum;
					      HSSFCell cell=null;
					      for(cellnum=firstcell;cellnum<lastcell;cellnum++)
					      {
					      		temp="";
						       cell=row.getCell(cellnum);
						       if(cell!=null)
						       {
						       	 switch (cell.getCellType()) 
						       	 {
									case HSSFCell.CELL_TYPE_BOOLEAN:
									    temp = String.valueOf((cell.getBooleanCellValue()));
									    break;
									case HSSFCell.CELL_TYPE_NUMERIC:
									    temp = String.valueOf(cell.getNumericCellValue());
									    break;
									case HSSFCell.CELL_TYPE_STRING:
									    temp = cell.getStringCellValue();
									    break;
									case HSSFCell.CELL_TYPE_BLANK:
									    break;
									case HSSFCell.CELL_TYPE_ERROR:
									    break;
									
									// CELL_TYPE_FORMULA will never happen
									case HSSFCell.CELL_TYPE_FORMULA: 
									    break;
						       	 }
				System.out.println ("第"+rownum+"行,第"+cellnum+"列:"+temp);
						      /*
						       if(cell!=null && cell.getCellType()==HSSFCell.CELL_TYPE_NUMERIC)
						         temp="" + cell.getNumericCellValue();
						       else if(cell!=null && cell.getCellType()==HSSFCell.CELL_TYPE_STRING)
						       {
						         temp="" + cell.getStringCellValue();
						       }
						       */
						       text.append(temp+" ");
					     	 }
				     	}
				     		text.append("\n");
			   		}
			   	}
			
		  }catch(Exception e) {
	   		System.out.println(e );
	  }
	  System.out.println (text.toString());
	  return text.toString();
	 }
}