Split XLAM into Multiple XLAM Files in C# .NET

Split XLAM File & Add Watermarks in .NET

Split a single XLAM 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 XLAM file format?

The XLAM file format is an extension used for Microsoft Excel add-in files. Add-ins are additional programs or functionality that can be added to Excel to extend its capabilities. XLAM files contain macros, user-defined functions, custom toolbars, and other automation features that enhance Excel’s functionality.

XLAM files are saved in a compiled format, which means that the code within the file is pre-compiled and ready to be executed by Excel. This offers improved performance compared to other file formats that store macros in a source code format (such as XLSM files). Additionally, XLAM files are typically password-protected to prevent unauthorized access and modifications to the code.

When an XLAM file is installed as an add-in in Excel, its functionality becomes available across multiple workbooks. This allows users to access and use the macros and custom functions provided by the add-in without having to copy the code to each individual workbook. XLAM files can be distributed and shared with others, enabling consistent automation across different Excel environments.

To use an XLAM file, it needs to be installed as an add-in in Excel. This can be done by going to the Excel Options menu, selecting the Add-Ins tab, and browsing for the XLAM file to add it as an add-in. Once installed, the macros and functions provided by the XLAM file can be accessed and used within Excel.

Learn

Split Single XLAM to Many XLAM Files in .NET

Split XLAM File & Add Watermarks in .NET

Download Document Splitter API

Split Text File into Many Files in C# .NET

Single Document Modification Operations

What is XLAM file format?

Popular Document Merger Options with .NET