Split XLSM into Multiple XLSM Files in C# .NET

Split XLSM File & Add Watermarks in .NET

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

The XLSM file format is an extension of the XLSX file format used for Microsoft Excel workbooks. Similar to XLSX, it is based on the Open XML file format and is associated with the Excel application. The “M” in XLSM stands for “macro-enabled”, indicating that it supports the inclusion of macros.

XLSM files store spreadsheet data, including worksheets, formulas, charts, and other elements commonly found in Excel workbooks. Additionally, XLSM files allow the embedding of VBA (Visual Basic for Applications) macros within the workbook. Macros are scripts written in VBA that automate tasks, perform calculations, and interact with the spreadsheet data.

By including macros in XLSM files, users can create customized functions, automate repetitive tasks, and enhance the functionality of their Excel workbooks. Macros can be written to manipulate data, generate reports, perform complex calculations, or interact with other applications.

When opening an XLSM file, Excel prompts the user to enable or disable macros due to security concerns. Enabling macros allows the embedded VBA code to execute, while disabling macros prevents potential security risks associated with malicious code.

XLSM files provide advanced features and customization options for Excel users who require automation beyond the capabilities of the standard XLSX format. They are commonly used in business environments, financial modeling, data analysis, and other scenarios where complex calculations and automation are necessary.

Learn

Split Single XLSM to Many XLSM Files in .NET

Split XLSM File & Add Watermarks in .NET

Download Document Splitter API

Split Text File into Many Files in C# .NET

Single Document Modification Operations

What is XLSM file format?

Popular Document Merger Options with .NET