Question: how to copy rows from one excel sheet to another using java?
Answer: Open the target exist excel file use Apache POI. Get selected data in list from source excel sheet. Clone the exist sheet to create a new one. Remove all rows in the new sheet. Save copied data into the new sheet.