C# Excel - Merge Excel Documents in C#.NET

Overview

RasterEdge C#.NET Excel document merging toolkit (XDoc.Excel) is designed to help .NET developers combine Excel document files created by different users to one Excel file. Thus, C#.NET Excel document merge library control can be counted as an efficient .NET doc solution for keeping Excel document files organized.

This C# .NET Excel document merging control is written in managed C# code and compatible with all .NET developing platforms, like ASP.NET web application and Windows Forms project. c# add watermark to existing pdf file using itextsharp, add image to pdf using itextsharp vb.net, extract text from pdf using itextsharp c#, barcode reader library vb.net, c# textbox read barcode scanner, itextsharp add annotation to existing pdf c#. Using this Excel document concatenating library SDK, C# developers can easily merge and append one Excel document to another Excel document file, and choose to create a new Excel file in .NET class application.

Besides C#.NET Excel document merging function, XDoc.Excel, a professional third-party .NET document imaging toolkit, also offers other advanced Excel document page processing and manipulating functions, such as Excel page insertion, Excel page deleting, Excel document splitting, Excel page reordering and Excel page image and text extraction. Remarkably, all those C#.NET Excel document page processing functions can be implemented independently, without using any Adobe-related software. c# create editable pdf, c# pdf highlight text, vb.net search pdf for text, vb net pdf compress and resize free, c# pdf add bookmark, modify pdf in vb.net, convert pdf to png vb.net.

Our .NET Excel SDK empowers C# programmers to easily merge and append Excel files with mature APIs. To be more specific, two or more input Excel documents can be merged and appended together according to its loading sequence, and then saved and output as a single Excel with user-defined location. asp.net core mvc pdf viewer, how to display pdf file in asp.net c#, how to add header and footer in pdf using itextsharp in asp.net, asp.net view tiff image, show image asp.net, best pdf preview in asp net c#, how to write pdf file in asp.net c#.

C# DLLs: Merge Excel Files

Add necessary references:

  RasterEdge.Imaging.Basic.dll

  RasterEdge.XDoc.Office.Inner.Common.dll

  RasterEdge.Imaging.Drawing.dll

  RasterEdge.Imaging.Processing.dll

  RasterEdge.XDoc.Office.Inner.Office03.dll

  RasterEdge.Imaging.Font.dll

  RasterEdge.XDoc.Excel.dll

  RasterEdge.XImage.Raster.Core.dll

  RasterEdge.XImage.Raster.dll

Using namespaces:

  using RasterEdge.Imaging.Basic;

  using RasterEdge.XDoc.Excel;

Combine and Merge Multiple Excel Files into One Using C#

This part illustrates how to combine three Excel files into a new file in C# application. You may also combine more Excel documents together.

String inputFilePath1 = Program.RootPath + "\\" + "1.xlsx";
String inputFilePath2 = Program.RootPath + "\\" + "2.xlsx";
String inputFilePath3 = Program.RootPath + "\\" + "3.xlsx";
String outputFilePath = Program.RootPath + "\\" + "Output.xlsx";
String[] inputFilePaths = new String[3] { inputFilePath1, inputFilePath2, inputFilePath3 };

// Combine three Excel files and output.
XLSXDocument.CombineDocument(inputFilePaths, outputFilePath);

Append Excel Document in C#

In addition, C# users can append a Excel file to the end of a current Excel document and combine to a single Excel file.

//  get XLSXDocument object from one file
String inputFilePath1 = Program.RootPath + "\\" + "1.xlsx";
XLSXDocument doc1 = new XLSXDocument(inputFilePath1);
//  get XLSXDocument object from another file
String inputFilePath2 = Program.RootPath + "\\" + "2.xlsx";
XLSXDocument doc2 = new XLSXDocument(inputFilePath2);

//  append the 2nd document
doc1.AppendDocument(doc2);

//  save the document
String outputFilePath = Program.RootPath + "\\" + "Output.xlsx";
doc1.Save(outputFilePath);