Merge multiple excel file into single excel work book

Question

Merge multiple excel file into single excel work book using c# in web application without any third party library.

Jignesh Kumar · Answer

Hi Vignesh, Please find below link https://stackoverflow.com/questions/27285615/how-do-i-merge-multiple-excel-files-to-a-single-excel-file https://www.c-sharpcorner.com/UploadFile/a08113/solutions-to-merge-multiple-excel-worksheets-into-one/

Raheel Ahmad · Answer

Hi Merging multiple excel files is a bit tricky but there are many solutions exist, I recommend to use ByteScout Spreadsheet SDK which have also provided sample code for this operation. See the code below { // Open existing Spreadsheets Spreadsheet document1 = new Spreadsheet(); document1.LoadFromFile(“workbook1.xls”); Spreadsheet document2 = new Spreadsheet(); document2.LoadFromFile(“workbook2.xls”); // Create output document Spreadsheet document3 = new Spreadsheet(); // Add new worksheet document3.Workbook.Worksheets.Add(); // Target row int targetRow = 0; // Copy cells from first document for ( int i = 0; i for ( int j = 0; j // Copy cells from second document for (int i = 0; i For more details follow the link below https://bytescout.com/articles/spreadsheet-sdk-c-merge-two-documents

Leon D · Answer

Hi, Check the blow link: https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Merge-Merge-Excel-Files-into-One-with-C-VB.NET.html