XDoc.Excel
Features
Tech Specs
How-to C#
Pricing

C# Excel How-Tos

PM > Install-Package XDoc.Excel

Overview Install Get to Start Basic SDK Concept Formats Supported Load, Save XLSX Preview XLSX Excel Conversion Document, Sheets Process Annotate Excel Text Search Edit Images Excel Thumbnail

C# Excel Library
C# Excel - Split Excel Document in C#.NET


Explain How to Split Excel Document in Visual C#.NET Application





C# Excel document splitting library control, XDoc.Excel, provides an advanced C# programming way to split Excel document into smaller Excel files in .NET developing applications. Using this C#.NET Excel document splitting library control, C# developers can easily and accurately disassemble multi-page Excel document into two or more separate Excel document files by page(s).

RasterEdge Visual C# .NET Excel document splitter control toolkit SDK can not only offer C# developers a professional .NET solution to split Excel document file but also provide them the ability to name outputted Excel document files with a customized name pattern using a few lines of simple Visual C# code.

This C#.NET Excel document splitting library control offers developers an efficient Excel document splitting approach, using which C# developers can split target Excel document file by specifying a page or pages. If needed, developers can also combine generated split Excel document files with other Excel files to form a new Excel file using RasterEdge XDoc.Excel. Besides, in the process of splitting Excel document, developers can also remove certain Excel page from target Excel file using C#.NET Excel page deletion API.

Please note, Excel file will be divided from the previous page of your defined page number which starts from 0. For example, your original Excel file contains 4 pages. If your page number is set as 1, then the two output Excel files will contains the first page and the later three pages respectively.


Split Excel file into two files in C#



This is an C# example of splitting a Excel file into multiple ones by number of pages. 

String inputFilePath = Program.RootPath + "\\" + "1.xlsx";
String outputFilePath1 = Program.RootPath + "\\" + "Split1.xlsx";
String outputFilePath2 = Program.RootPath + "\\" + "Split2.xlsx";
String[] outputOps = new  String[] { outputFilePath1, outputFilePath2 };
//  split a Excel file with options
XLSXDocument.SplitDocument(inputFilePath, 2, outputOps);


Split Excel Document into Multiple Excel Files in C#



You can use the following C# demo to split Excel document to four files. 

String inputFilePath = Program.RootPath + "\\" + "1.xlsx";
String outputFileName = "Output.xlsx";
int[] splitIndex = new int[3] { 1, 3, 5 }; // Valid value for each index: 1 to (Page Count - 1).

// Create output Excel file path list
List<String> outputFilePaths = new List<String>();
for (int i = 0; i <= splitIndex.Length; i++)
{
        outputFilePaths.Add(Program.RootPath + "\\" + outputFileName + "_" + i.ToString() + ".xlsx");
}

// Split input Excel file to 4 files:
// File 0: page 0.
// File 1: page 1 ~ 2.
// File 2: page 3 ~ 4.
// File 3: page 5 ~ the last page.
XLSXDocument.SplitDocument(inputFilePath, splitIndex, outputFilePaths.ToArray());