consolidation of xls problem

Nehru · September 11th, 2006, 04:03 AM

hi friends i need to consolidate some xls files data in to one new xls, any body can help me how to do this in c#.net?

Elias AS · July 24th, 2013, 05:22 AM

Hi, here is how you can create XLS file in .NET from multiple XLS files:

Code:

string[] filePaths = { "C:\\Book1.xls", "C:\\Book2.xls", "C:\\Book3.xls" };
ExcelFile newFile = new ExcelFile();

foreach (string path in filePaths)
{
    ExcelFile temp = ExcelFile.Load(path);
    foreach (ExcelWorksheet sheet in temp.Worksheets)
        newFile.Worksheets.AddCopy(sheet.Name, sheet);
}

newFile.Save("C:\\New Book.xls");

I used this .NET Excel component.