JAVA导入数据到Excel

1 import java.io.File;
  2 import java.io.FileInputStream;
  3 import java.io.FileNotFoundException;
  4 import java.io.FileOutputStream;
  5 import java.io.IOException;
  6 import java.lang.reflect.Field;
  7 import java.lang.reflect.Method;
  8 import java.util.ArrayList;
  9 import java.util.List;
 10 
 11 import org.apache.poi.hssf.usermodel.HSSFRow;
 12 import org.apache.poi.hssf.usermodel.HSSFSheet;
 13 import org.apache.poi.hssf.usermodel.HSSFWorkbook;
 14 import org.apache.poi.ss.usermodel.Cell;
 15 import org.apache.poi.ss.usermodel.Row;
 16 import org.springframework.stereotype.Component;
 17 
 18 /**
 19  * @Description: 
 20  * @author 21  * @date 创建时间：2016年12月8日下午2:38:47
 22  * @version 1.0
 23  */
 24 @Component
 25 public class ExcelManage {
   
 26     private HSSFWorkbook workbook = null;  
 27     
 28     /** 
 29      * 判断文件是否存在
 30      * @param filePath  文件路径 
 31      * @return 
 32      */  
 33     public boolean fileExist(String filePath){
     
 34          boolean flag = false;  
 35          File file = new File(filePath);  
 36          flag = file.exists();  
 37          return flag;  
 38     }  
 39     
 40     /** 
 41      * 判断文件的sheet是否存在
 42      * @param filePath   文件路径 
 43      * @param sheetName  表格索引名 
 44      * @return 
 45      */  
 46     public boolean sheetExist(String filePath,String sheetName){
     
 47          boolean flag = false;  
 48          File file = new File(filePath);  
 49          if(file.exists()){
       //文件存在  
 50             //创建workbook  
 51              try {
     
 52                 workbook = new HSSFWorkbook(new FileInputStream(file));  
 53                 //添加Worksheet（不添加sheet时生成的xls文件打开时会报错)  
 54                 HSSFSheet sheet = workbook.getSheet(sheetName);    
 55                 if(sheet!=null)  
 56                     flag = true;  
 57             } catch (Exception e) {
     
 58                 e.printStackTrace(