POI的使用
[JAVA_Apache]POI套件的使用_產出EXCEL文件_產出EXCEL方法(Workbook)

           

public static void training1() throws IOException {

 FileOutputStream fileOut = null ;

  try {

   //這裡只是純產出excel檔案而以

   //產出Excel 97（XLS）文件格式

   Workbook hssfwb = new HSSFWorkbook();

   fileOut = new FileOutputStream("workbook.xls");

   hssfwb.write(fileOut);

   fileOut.close();

   //Excel 2007的（XLSX）文件格式

   Workbook xssfwb = new XSSFWorkbook();

   fileOut = new FileOutputStream("workbook.xlsx");

   xssfwb.write(fileOut);

   fileOut.close();

  }

  catch (IOException ioe) {

   ioe.printStackTrace();

  }

  finally {

   if (null != fileOut) {

    fileOut.close();

   }

  }

 }



 

public static void training2() throws IOException {

  // 讀取一個原有的excel檔案

  FileInputStream fileInputStream = null;

  Workbook hssfWorkbook = null;

  try {

   fileInputStream = new FileInputStream(new File("D:/training1.xls"));

   if (null != fileInputStream) {

    try {

     hssfWorkbook = new HSSFWorkbook(fileInputStream);

    }

    catch (IOException e) {

     e.printStackTrace();

    }

   }

  }

  catch (IOException ioe) {

   ioe.printStackTrace();

   throw ioe;

  }

  finally {

   if (null != fileInputStream) {

    fileInputStream.close();

   }

  }

  //將剛讀取的excel檔案,產出為另一個excel檔案。

  FileOutputStream fileOutputStream = null;

  try {

   fileOutputStream = new FileOutputStream(new File("D:/trainingto.xls"));

   hssfWorkbook.write(fileOutputStream);

   fileOutputStream.flush();

  }

  catch (IOException ioe) {

   ioe.printStackTrace();

   throw ioe;

  }

  finally {

   if (null != fileOutputStream) {

    fileOutputStream.close();

   }

  }

 }










其它文章

 


arrow
arrow
    文章標籤
    用法 java 測試 程式 fileinputstream hssfworkbook null ioexception excel workbook 產出 xls fileout fileoutputstream poi Workbook
    全站熱搜
    創作者介紹
    創作者 PG Levin Li 的頭像
    PG Levin Li

    程式開發學習之路

    PG Levin Li 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄