Spreadsheet Splitter – Split Any Workbook into Separate Files

using Sheetize;

var license = new Sheetize.License();
license.SetLicense("Sheetize.SpreadsheetSplitter_for_.NET.lic");

var loadOptions = new LoadOptions
{
InputFile = @"C:\Data\MasterReport.xlsx"
};

var saveOptions = new SplitterSaveOptions
{
// Folder where each sheet will be written as its own workbook
OutputFolder = @"E:\SplitSheets\"
};

SpreadsheetSplitter.Process(loadOptions, saveOptions);

using Sheetize;
using System;
using System.IO;
using System.Linq;

try
{
// 1️⃣ License activation
var license = new Sheetize.License();
license.SetLicense(@"C:\Licenses\Sheetize.SpreadsheetSplitter_for_.NET.lic");

// 2️⃣ Input workbook
string sourceFile = @"C:\Data\AnnualReport.xlsb";

// 3️⃣ Supported extensions (both input & output)
var supported = new[]
{
".xlsx",".xlsb",".xlsm",".xltm",".xlam",
".xls",".xml",".xlt"
};

// 4️⃣ Validate source
if (!File.Exists(sourceFile))
throw new FileNotFoundException($"Source not found: {sourceFile}");
if (!supported.Contains(Path.GetExtension(sourceFile).ToLower()))
throw new NotSupportedException($"Unsupported source type: {sourceFile}");

// 5️⃣ Prepare options
var load = new LoadOptions { InputFile = sourceFile };
var save = new SplitterSaveOptions
{
OutputFolder = @"C:\Data\SplitOutput\"
};

// 6️⃣ Execute split
SpreadsheetSplitter.Process(load, save);
Console.WriteLine($"✅ Split succeeded – files saved to {save.OutputFolder}");
}
catch (Exception ex)
{
// Centralised error logging (Serilog, NLog, Application Insights, etc.)
Console.Error.WriteLine($"❌ Split failed: {ex.GetType().Name} – {ex.Message}");
// Optionally re‑throw for upstream handling
// throw;
}

# 1️⃣ Install the NuGet package
dotnet add package Sheetize

# 2️⃣ Grab a free trial licence (no credit‑card required)
# https://purchase.sheetize.com/temp-license/113911

# 3️⃣ Place the .lic file in your project, e.g. ./Licenses/Sheetize.SpreadsheetSplitter_for_.NET.lic

# 4️⃣ Use the sample code above – compile, run, and watch individual sheet files appear!