Merging Two excel files as two sheets in one workbook in java

Question

I have two xlsx files at folder C:\DemoFilesExcel\demo1.xlsx and C:\DemoFilesExcel\demo2.xlsx.

I want to create a new xlsx C:\DemoFilesExcel\merged.xlsx that will have these two files as two sheets in merged.xlsx workbook.

This is to be done using apache POI in java. Any idea how to do

Answer 1

Basically for this, you need to create the workbook with the first source file

and again create a workbook with a second source file

and repeat it for how many ever you want to open  

then you need to call the create() using the second source file

then do this for all the workbooks then save the output file by the name save() method if the workbook classes