java 读excel

package cn.com.travel.action;

import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Date;
import java.util.List;

import javax.swing.JOptionPane;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

public class ReadExecl {

 public static void main(String[] args) throws FileNotFoundException, IOException
 {
     File file = new File("d:\\1.xls");
     String[][] result = getData(file, 1);
        int rowLength = result.length; 
        for(int i=0;i<rowLength;i++) {
       //你的操作
       
        }
      
       
 }
 
 
 
 public static void find(String pdfPath,String fileName,String url) throws IOException{
     File pdfFile = new File(pdfPath);
        File[] files = pdfFile.listFiles();
        if(files == null){
         return;
        }
        for(int i=0;i<files.length;i++){
//         System.out.println(files[i].getName());
         if(files[i].getName() == null){
          return ;
         }
       if(files[i].getName().contains(fileName+"_")){
        copyFile(files[i],new File(url+files[i].getName()));
       }
       if(files[i].getName().endsWith(".dwg") || files[i].getName().endsWith(".jpg")
           || files[i].getName().endsWith(".png")){
        if(files[i].getName().contains(fileName+"-")){
          copyFile(files[i],new File(url+files[i].getName()));
        }
       }
      // files[i].delete();
        }
 }
 

 
    public static String[][] getData(File file, int ignoreRows)throws FileNotFoundException, IOException {
 
       List<String[]> result = new ArrayList<String[]>();
 
       int rowSize = 0;
 
       BufferedInputStream in = new BufferedInputStream(new FileInputStream(file));
 
       // ��HSSFWorkbook
 
       POIFSFileSystem fs = new POIFSFileSystem(in);
 
       HSSFWorkbook wb = new HSSFWorkbook(fs);
 
       HSSFCell cell = null;
 
       for (int sheetIndex = 0; sheetIndex < wb.getNumberOfSheets(); sheetIndex++) {
 
           HSSFSheet st = wb.getSheetAt(sheetIndex);
 
           // ��һ��Ϊ���⣬��ȡ
 
           for (int rowIndex = ignoreRows; rowIndex <= st.getLastRowNum(); rowIndex++) {
 
              HSSFRow row = st.getRow(rowIndex);
 
              if (row == null) {
 
                  continue;
 
              }
 
              int tempRowSize = row.getLastCellNum() + 1;
 
              if (tempRowSize > rowSize) {
 
                  rowSize = tempRowSize;
 
              }
 
              String[] values = new String[rowSize];
 
              Arrays.fill(values, "");
 
              boolean hasValue = false;
 
              for (short columnIndex = 0; columnIndex <= row.getLastCellNum(); columnIndex++) {
 
                  String value = "";
 
                  cell = row.getCell(columnIndex);
 
                  if (cell != null) {
 
 
                     cell.setEncoding(HSSFCell.ENCODING_UTF_16);
 
                     switch (cell.getCellType()) {
 
                     case HSSFCell.CELL_TYPE_STRING:
 
                         value = cell.getStringCellValue();
 
                         break;
 
                     case HSSFCell.CELL_TYPE_NUMERIC:
 
                         if (HSSFDateUtil.isCellDateFormatted(cell)) {
 
                            Date date = cell.getDateCellValue();
 
                            if (date != null) {
 
                                value = new SimpleDateFormat("yyyy-MM-dd")
 
                                       .format(date);
 
                            } else {
 
                                value = "";
 
                            }
 
                         } else {
 
                            value = new DecimalFormat("0").format(cell
 
                                   .getNumericCellValue());
 
                         }
 
                         break;
 
                     case HSSFCell.CELL_TYPE_FORMULA:
 
 
                         if (!cell.getStringCellValue().equals("")) {
 
                            value = cell.getStringCellValue();
 
                         } else {
 
                            value = cell.getNumericCellValue() + "";
 
                         }
 
                         break;
 
                     case HSSFCell.CELL_TYPE_BLANK:
 
                         break;
 
                     case HSSFCell.CELL_TYPE_ERROR:
 
                         value = "";
 
                         break;
 
                     case HSSFCell.CELL_TYPE_BOOLEAN:
 
                         value = (cell.getBooleanCellValue() == true ? "Y"
 
                                : "N");
 
                         break;
 
                     default:
 
                         value = "";
 
                     }
 
                  }
 
                  if (columnIndex == 0 && value.trim().equals("")) {
 
                     break;
 
                  }
 
                  values[columnIndex] = rightTrim(value);
 
                  hasValue = true;
 
              }
 
 
 
              if (hasValue) {
 
                  result.add(values);
 
              }
 
           }
 
       }
 
       in.close();
 
       String[][] returnArray = new String[result.size()][rowSize];
 
       for (int i = 0; i < returnArray.length; i++) {
 
           returnArray[i] = (String[]) result.get(i);
 
       }
 
       return returnArray;
 
    }
 
   

     public static String rightTrim(String str) {
 
       if (str == null) {
 
           return "";
 
       }
 
       int length = str.length();
 
       for (int i = length - 1; i >= 0; i--) {
 
           if (str.charAt(i) != 0x20) {
 
              break;
 
           }
 
           length--;
 
       }
 
       return str.substring(0, length);
 
    }

}