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

0 votes
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
Feb 21, 2022 in Database by Edureka
• 13,670 points
901 views

1 answer to this question.

0 votes
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
answered Feb 21, 2022 by gaurav
• 23,260 points

Related Questions In Database

0 votes
0 answers

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

I have two xlsx files at folder ...READ MORE

Mar 10, 2022 in Database by Edureka
• 13,670 points
1,449 views
0 votes
0 answers

How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

 need the row/column combinations marked with an ...READ MORE

Feb 24, 2022 in Database by Edureka
• 13,670 points
1,806 views
0 votes
1 answer

Java Apache POI Excel save as PDF

For the software to run, you'll need ...READ MORE

answered Mar 31, 2022 in Database by gaurav
• 23,260 points
7,554 views
0 votes
1 answer

How to transform multiple tables in one excel sheet to one table with Power BI?

If my prediction is correct- You have a ...READ MORE

answered Apr 4, 2022 in Database by Edureka
• 13,670 points
2,629 views
0 votes
1 answer
0 votes
1 answer

What is the better API to Reading Excel sheets in java - JXL or Apache POI

Here are the things where both APIs ...READ MORE

answered Oct 9, 2022 in Others by narikkadan
• 63,700 points
2,906 views
0 votes
1 answer

How to get columns from Excel files using Apache POI?

The only way to see all the ...READ MORE

answered Oct 18, 2022 in Others by narikkadan
• 63,700 points
4,557 views
0 votes
1 answer

Hours and minutes difference between two times in Excel

Using the TEXT function in Excel is ...READ MORE

answered Mar 25, 2022 in Database by gaurav
• 23,260 points
844 views
0 votes
1 answer

Conditional Sum in Excel that counts values above X as X

B1 formula is: =SUMIF(A1:A5,"<=5") +COUNTIF(A1:A5,">5") *5 Fill in the blanks ...READ MORE

answered Mar 31, 2022 in Database by gaurav
• 23,260 points
277 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP