学步园

*
 * Created on 2005/07/18
 * 使用poi-2.5.1-final-20050804.jar
 */
package com.nova.colimas.common.doc;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;
import java.io.FileInputStream;
import java.io.FileOutputStream;
/**
 * Deal with Excel Files.
 * @author tyrone
 *
 */
public class ExcelProcess {
 
 public static String run(String filename){
  String text=null;
  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++){
       cell=row.getCell(cellnum);
       if(cell!=null && cell.getCellType()==HSSFCell.CELL_TYPE_NUMERIC)
         text=text +cell.getNumericCellValue();
       else if(cell!=null && cell.getCellType()==HSSFCell.CELL_TYPE_STRING){
         text=text +cell.getStringCellValue();
       }
      }
      text=text+"/n";
     }
    }
   }