Merge multiple excel file into single excel work book

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 < 10; i++) { for (int j = 0; j < 12; j++) { document3.Worksheet(0).Cell(targetRow, j).Value = document1.Worksheet(0).Cell(i, j).Value; } targetRow++; } // Copy cells from second document for (int i = 0; i < 10; i++) { for (int j = 0; j < 12; j++) { document3.Worksheet(0).Cell(targetRow, j).Value = document2.Worksheet(0).Cell(i, j).Value; } targetRow++; } // delete output file if exists already if (File.Exists("Output.xls")){ File.Delete("Output.xls"); } // Save document document3.SaveAs("output.xls"); // Close document document3.Close(); // Open document in default xls viewer Process.Start("Output.xls"); } } } [/csharp]

For more details follow the link below

https://bytescout.com/articles/spreadsheet-sdk-c-merge-two-documents

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar8y ago
Accepted 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/
0
Raheel Ahmad7y ago
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 < 10; i++) { for (int j = 0; j < 12; j++) { document3.Worksheet(0).Cell(targetRow, j).Value = document1.Worksheet(0).Cell(i, j).Value; } targetRow++; } // Copy cells from second document for (int i = 0; i < 10; i++) { for (int j = 0; j < 12; j++) { document3.Worksheet(0).Cell(targetRow, j).Value = document2.Worksheet(0).Cell(i, j).Value; } targetRow++; } // delete output file if exists already if (File.Exists("Output.xls")){ File.Delete("Output.xls"); } // Save document document3.SaveAs("output.xls"); // Close document document3.Close(); // Open document in default xls viewer Process.Start("Output.xls"); } } } [/csharp]
For more details follow the link below
https://bytescout.com/articles/spreadsheet-sdk-c-merge-two-documents
0
Leon D8y ago
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
0