Split XLSX into Multiple XLSX Files in C# .NET

Split XLSX File & Add Watermarks in .NET

Split a single XLSX document to multiple independent documents and insert image or text watermarks to each of the splitted files using C# .NET.

Instantiate Watermarker with splitted document
Instantiate watermark font, create TextWatermark object & set watermark properties
Add watermark and save watermarked document
Set output path where files will be saved after splitting
Instantiate SplitOptions object with path of splitted file and number of pages to be splitted
Create Merger object with input document and split using SplitOptions

Download Document Splitter API

You require GroupDocs.Merger & GroupDocs.Watermark namespaces to perform document splitter operations within PDF, Microsoft Office, HTML, OpenDocument and many other file formats. Explore other .NET APIs for Office documents as offered by Conholdate.Total.

Get the respective assembly files from the downloads or fetch the whole package from NuGet to add ‘Conholdate.Total` directly in your workspace.

	// Supports merging Microsft Word, Excel, PowerPoint, Visio, OpenDocument, HTML, eBook and PostScript file formats
	// Supported file formats: https://docs.groupdocs.com/merger/net/supported-document-formats/

	using (Watermarker watermarker = new Watermarker("input.pdf"))
	{
	Font font = new Font("Arial", 19, FontStyle.Bold \| FontStyle.Italic);

	TextWatermark watermark = new TextWatermark("my watermark", font);

	watermark.ForegroundColor = Color.Red;
	watermark.BackgroundColor = Color.Blue;
	watermark.TextAlignment = TextAlignment.Right;
	watermark.Opacity = 0.5;

	watermarker.Add(watermark);
	watermarker.Save("output.pdf");
	}

	string outputFolder = @"c:\output\";

	SplitOptions splitOptions = new SplitOptions(outputFolder + "document_{0}.{1}", new int[] { 1, 2, 4 });

	using (Merger merger = new Merger("output.pdf"))
	{
	merger.Split(splitOptions);
	}

view raw add-watermark-to-a-single-pdf-and-split-to-multiple-pdf-files.cs hosted with ❤ by GitHub

Split Text File into Many Files in C# .NET

Using text splitter library for .NET applications – split each line or multi-lines of the source text file into a separate resultant .txt file by using a couple lines of C# code.

Initialize TextSplitOptions class with output files path format, desired TextSplitMode and line numbers
Instantiate Merger object with source document path or stream
Call Split method and pass TextSplitOptions object to save the resultant text files

Single Document Modification Operations

Perform multi-functional document manipulation features in a variety of document formats such as Word, Excel spreadsheet, Presentations, RTF, PDF, Visio, HTML, OneNote, XPS and many others by adding just a few lines of C# code.

The major single document operations include moving pages within a document to a new position, removing a single page or a collection or selected pages, swapping the page positions, extracting specific pages from the document, changing the page orientation to portrait or landscape mode and rotating the pages of the source document to 90, 180 or 270 degree angle.

	// Supports merging Microsft Word, Excel, PowerPoint, Visio, OpenDocument, HTML, eBook and PostScript file formats
	// Supported file formats: https://docs.groupdocs.com/merger/net/supported-document-formats/

	string filePath = @"c:\sample.txt";
	string filePathOut = @"c:\output\line_{0}.{1}";

	TextSplitOptions splitOptions = new TextSplitOptions(filePathOut, new int[] { 3, 6 });

	using (Merger merger = new Merger(filePath))
	{
	merger.Split(splitOptions);
	}

view raw split-text-file-to-several-text-files.cs hosted with ❤ by GitHub

What is XLSX file format?

The XLSX file format is a widely used file format for storing spreadsheet data. It was introduced by Microsoft as part of their Microsoft Office suite, specifically for the Excel application. XLSX stands for Excel Open XML Spreadsheet. Unlike its predecessor, the XLS format, which was based on a proprietary binary file structure, XLSX is based on the Open XML file format.

XLSX files are structured as a collection of XML files compressed into a single ZIP archive. This XML-based structure allows for more efficient storage and faster data processing. XLSX files store data in a tabular format, with rows and columns that can contain text, numbers, formulas, and other types of data. They also support formatting options such as cell styles, fonts, colors, and conditional formatting.

One of the advantages of the XLSX format is its compatibility across different platforms and software applications. Many spreadsheet programs, including Microsoft Excel, Google Sheets, and LibreOffice Calc, can open and edit XLSX files. This makes it easy to share and collaborate on spreadsheet data with others, regardless of the software they are using.

XLSX files also offer features like data validation, filtering, sorting, and the ability to create charts and graphs based on the data. Additionally, XLSX files can contain multiple sheets within a single file, allowing users to organize and manage different sets of data within a single document.

Learn

Split Single XLSX to Many XLSX Files in .NET

Split XLSX File & Add Watermarks in .NET

Download Document Splitter API

Split Text File into Many Files in C# .NET

Single Document Modification Operations

What is XLSX file format?

Popular Document Merger Options with .NET