Microsoft® Excel File Splitting via .NET
Split single Excel document into different files using C# code within .NET based applications
.NET Excel Library is capable to split Excel document into multiple spreadsheets within .NET based applications. Supported file formats include XLS, XLSX, XLSB, XLSM, ODS.
Split Excel Document into Multiple Files
The simplest way to split Excel files sheet wise is, Accessing all sheets via Worksheets , Iterating through each sheet and calling the Copy method. Finally saving it into a specified path.
- Load the Excel file with full path using Workbook class .
- Iterate throug each sheet
- Create a new Workbook class object
- Copy the sheet via Copy method
- Call the Save() method and pass the file name (full path) having relevant SaveFormat.
C# Code to Split Excel Files
Split Excel Worksheet into Panes
For splitting worksheet window into panes, API provides Split method of worksheet class, that provides the splitted view of worksheet. To remove splitted view API provides RemoveSplit method . Finally save it into a specified path.