利用HSSFWorkbook进行Excle的读写

利用HSSFWorkbook进行Excle的读写

  
  
  

   
   
   import java.io.File;  
  
  
  
import java.io.FileInputStream;  
import java.io.FileNotFoundException;  
import java.io.FileOutputStream;  
import java.io.IOException;  
import java.io.InputStream;  
import java.io.OutputStream;  
import java.text.ParseException;  
import java.text.SimpleDateFormat;  
import java.util.ArrayList;  
import java.util.List;  
  
import org.apache.poi.hssf.usermodel.HSSFCell;  
import org.apache.poi.hssf.usermodel.HSSFCellStyle;  
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.hssf.util.HSSFColor;  
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;  
import org.apache.poi.poifs.filesystem.POIFSFileSystem;  
import org.apache.poi.ss.usermodel.Cell;  
import org.apache.poi.ss.usermodel.CellStyle;  
import org.apache.poi.ss.usermodel.Row;  
import org.apache.poi.ss.usermodel.Sheet;  
import org.apache.poi.ss.usermodel.Workbook;  
import org.apache.poi.ss.usermodel.WorkbookFactory;  
import org.apache.poi.ss.util.WorkbookUtil;  
  
  
public class ExcelUtilWithXSSF {  
    public static void main(String[] args) {  
        try {  
            getExcelAsFile("D:/ftp/students.xls");  
        } catch (FileNotFoundException e) {  
            e.printStackTrace();  
        } catch (IOException e) {  
            e.printStackTrace();  
        } catch (InvalidFormatException e) {  
            e.printStackTrace();  
        }  
          
          
//      try {  
//          CreateExcelDemo1();  
//      } catch (ParseException e) {  
//          e.printStackTrace();  
//      }  
          
 
    }  
      
    /** 
     * 得到Excel，并解析内容  对2007及以上版本 使用XSSF解析 
     * @param file 
     * @throws FileNotFoundException 
     * @throws IOException 
     * @throws InvalidFormatException  
     */  
    public static void getExcelAsFile(String file) throws FileNotFoundException, IOException, InvalidFormatException{  
//      1