How to Merge excel files in POI

  

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.IOException;

  

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

  

public class MergeXSLFiles {

  

public static void mergeExcelFiles() {

HSSFWorkbook book1 = null;

HSSFWorkbook book2 = null;

HSSFSheet sheet1 = null;

HSSFSheet sheet2 = null;

  

try {

book1 = new HSSFWorkbook(new FileInputStream(

"..\\com\\utilities\\excel\\Book1.xls"));

    sheet1 = book1.getSheetAt(0);

  

    book2 = new HSSFWorkbook(new FileInputStream(

                       "..\\com\\utilities\\excel\\Book2.xls"));

    sheet2 = book2.getSheetAt(0);

    

        try {

        AdvancedWorkbook mergedBook = new AdvancedWorkbook();

         

        mergedBook.addSheet(sheet1);

        mergedBook.setSheetName(0, book1.getSheetName(0));

  

        mergedBook.addSheet(sheet2);

       mergedBook.setSheetName(1, book2.getSheetName(0));

  

        FileOutputStream fileOut = new FileOutputStream(

        "..\\src\\com\\utilities\\excel\\Merged.xls"        ,false);

        mergedBook.write(fileOut);

        fileOut.close();

  

        System.out.println("Merged file has been created succesfully");

         } catch ( Exception ex ) {

         ex.printStackTrace();

         }

} catch (FileNotFoundException e) {

System.out.println("==> File Not found");

} catch (IOException e) {

System.out.println("==> IO Exception");

}

}

/**

 * @param args

 */

public static void main(String[] args) {

mergeExcelFiles();

}

}