Spreadsheet Splitter

The Sheetize Spreadsheet Splitter for .NET helps developers split large spreadsheet files into smaller parts, ideal for data distribution and management.

Key Features

Split Spreadsheets into Smaller Files

Split large spreadsheet files by sheet, range, or custom rules for easier handling and sharing.

Detailed Guide

Splitting a Spreadsheet

To split a spreadsheet into multiple smaller files:

  1. Initialize the Splitter: Create an instance of SpreadsheetSplitter.
  2. Set Splitting Criteria: Use SplitterOptions to specify how to split (e.g., by sheet or by row count).
  3. Define Input and Output Paths: Set the input file and the paths for the output split files.
  4. Execute the Split: Call the Process method to split the file.

Example: Split XLSX by Sheet

// Step 1: Initialize the Spreadsheet Splitter
var splitter = new SpreadsheetSplitter();

// Step 2: Configure options for splitting by sheet
var options = new SplitterOptions(SplitMode.BySheet);

// Step 3: Set file paths
options.AddInput(new FileDataSource("input.xlsx"));
options.AddOutput(new FileDataSource("output_directory"));

// Step 4: Execute the split process
splitter.Process(options);

This tool is perfect for dividing large files into smaller, manageable pieces, making data more accessible and easier to work with.

 English