1. Products
  2.   Conholdate.Total
  3.   .NET
  4.   ODS Merger

Split Single ODS to Many ODS Files in .NET

C# .NET ODS splitter API to split a single ODS file to several one page or multipage ODS files. Split documents and images using different filters by specifying exact page numbers, start or end page numbers and even or odd page numbers. Perform split operation to divide HTML, PDF, Text, OpenDocument, Microsoft Word, Excel, PowerPoint, Visio and OneNote documents to multiple resultant documents.

Download

Split ODS File & Add Watermarks in .NET

Split a single ODS 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);
}

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);
}

What is ODS file format?

The ODS file format, short for OpenDocument Spreadsheet, is an open standard file format used for storing spreadsheet data. It is part of the OpenDocument format (ODF) family, which is an international standard for office documents. ODS files are typically associated with spreadsheet software like LibreOffice Calc and Apache OpenOffice Calc.

ODS files store spreadsheet data in a structured manner, including worksheets, cells, formulas, formatting, and other spreadsheet elements. They can contain multiple sheets within a single file, allowing for complex and organized data structures. ODS files are saved in a compressed ZIP archive format, which makes them smaller in size and easier to share or store.

One of the main advantages of the ODS format is its openness and compatibility. Being an open standard, ODS files can be opened and edited by a wide range of spreadsheet applications that support the OpenDocument format. This ensures interoperability between different software and reduces the risk of data loss or format incompatibility.

ODS files offer features similar to proprietary spreadsheet formats, such as XLSX, including support for formulas, charts, conditional formatting, and data validation. They also support exporting to other common formats like CSV, PDF, and HTML.

To create an ODS file, you can use spreadsheet software like LibreOffice Calc or Apache OpenOffice Calc, which provide native support for saving files in the ODS format. To open an ODS file, you can use any spreadsheet software that supports the OpenDocument format or import the file into a compatible application.

Learn

Popular Document Merger Options with .NET

Merge PDF Files

(Portable Document Format)

Merge WORD Files

(Word Processing Files)

Merge EXCEL Files

(Spreadsheet Files)

Merge VISIO Files

(Visio Diagram Files)

Merge WEB Files

(Web Files)

Merge DOC Files

(Microsoft Word Binary Format)

Merge DOCX Files

(Office 2007+ Word Document)

Merge DOCM Files

(Microsoft Word 2007 Marco File)

Merge DOT Files

(Microsoft Word Template Files)

Merge DOTM Files

(Microsoft Word 2007+ Template File)

Merge DOTX Files

(Microsoft Word Template File )

Merge RTF Files

(Rich Text Format)

Merge TXT Files

(Text Document)

Merge XLS Files

(Microsoft Excel Spreadsheet (Legacy))

Merge XLSB Files

(Excel Binary Workbook)

Merge XLSM Files

(Macro-enabled Spreadsheet)

Merge XLSX Files

(Open XML Workbook)

Merge XLT Files

(Excel 97 - 2003 Template)

Merge XLTM Files

(Excel Macro-Enabled Template)

Merge XLTX Files

(Excel Template)

Merge XLAM Files

(Excel Macro-Enabled Add-In)

Merge CSV Files

(Comma Seperated Values)

Merge TSV Files

(Tab Seperated Values)

Merge PPT Files

(Microsoft PowerPoint 97-2003)

Merge PPTX Files

(Open XML presentation Format)

Merge PPS Files

(PowerPoint Slide Show)

Merge PPSX Files

(PowerPoint Slide Show)

Merge VDX Files

(Vector Design eXchange)

Merge VSDM Files

(Visio Macro-Enabled Drawing)

Merge VSDX Files

(Visio Drawing)

Merge VSSM Files

(Visio SmartShape Master)

Merge VSSX Files

(Visio Stencil File)

Merge VSTM Files

(Visio Macro-Enabled Drawing Template)

Merge VSTX Files

(Visio Drawing Template)

Merge VSX Files

(Visio Stencil XML File)

Merge VTX Files

(Anim8or 3D Model)

Merge ONE Files

(OneNote Document)

Merge HTML Files

(Hyper Text Markup Language)

Merge MHT Files

(MHTML Web Archive)

Merge MHTML Files

(Web Page Archive Format)

Merge ODP Files

(OpenDocument Presentation Format)

Merge ODS Files

(OpenDocument Spreadsheet)

Merge ODT Files

(OpenDocument Text File Format)

Merge OTP Files

(OpenDocument Standard Format)

Merge OTT Files

(OpenDocument Standard Format)

Merge EPUB Files

(Open eBook File)

Merge ERR Files

(Error Report File)

Merge PS Files

(PostScript File)

Merge TEX Files

(LaTeX Source Document)

Merge XPS Files

(XML Paper Specifications)

 English