Edit Documents via C# / VB.NET

It is a .NET API that enhances your apps to perform document, spreadsheets, DSV & XML files editing operations for a wide range of file formats.

Document Editor Library for .NET

Edit word processing documents in a flow or paged mode.
Fetch language information for multi-lingual document editing.
Extract font information to provide consistent editing and appearance behavior.
Edit multi-tabbed spreadsheets.
Supports DSV (Delimiter-Separated Values) documents.
Specify separator, flexible numeric and data conversion for CSV & TSV files.
Availability of memory usage optimization for large CSV & TSV files.
Fix incorrect XML document structure.
Recognize URIs and email addresses in XML files.
Extract basic information about the edited document.
Set character encoding of the input text document.
Grab document metadata information.
Fetch whole HTML document or BODY content.
Get HTML documents along with all its resources (stylesheets, images).
Open any supported format file in HTML format and save to disk.
Fetch HTML markup from DB or remote storage.

Editable File Formats

Word Processing: DOC, DOCX, DOCM, DOT, DOTM, DOTX, FlatOPC, ODT, OTT, RTF, WordML
Spreadsheet: XLS, XLT, XLSX, XLSM, XLTX, XLTM, XLSB, XLAM, SXC, SpreadsheetML, ODS, FODS, DIF, DSV, CSV, TSV
Presentation: PPT, PPTX, PPTM, PPS, PPSX, PPSM, POT, POTX, ODP, OTP
Other: TXT, HTML, XML, MOBI

Auto-detect File Formats

Word Processing: DOC, DOCX, DOCM, DOT, DOTM, DOTX, ODT, OTT, RTF
Spreadsheet: XLS, XLT, XLSX, XLSM, XLTX, XLTM, XLSB, XLAM, SXC, SpreadsheetML, ODS, FODS, DIF
Presentation: PPT, PPTX, PPTM, PPS, PPSX, PPSM, POT, POTX, ODP, OTP
Ebook: MOBI

Platform Independence

GroupDocs.Editor for .NET does not require any external software or third party tool to be installed. GroupDocs.Editor for .NET supports any 32-bit or 64-bit operating system where .NET or Mono framework is installed. The other details are as follows:

Microsoft Windows: Microsoft Windows Desktop (x86, x64) (XP & up), Microsoft Windows Server (x86, x64) (2000 & up), Windows Azure macOS: Mac OS X Linux: Linux (Ubuntu, OpenSUSE, CentOS and others) Development Environments: Microsoft Visual Studio (2010 & up), Xamarin.Android, Xamarin.IOS, Xamarin.Mac, MonoDevelop 2.4 and later. Supported Frameworks: GroupDocs.Editor for .NET supports .NET and Mono frameworks.

Load, Edit & Save Multi-tab Spreadsheet

//1. Get a path to the input file (or stream with file content).
//In this case it is sample XLSX (OOXML) with two tabs.
string inputFilePath = Constants.SAMPLE_XLSX;

//2. Load it into Editor instance from stream
using (FileStream inputStream = File.OpenRead(inputFilePath))
{
    using (Editor editor = new Editor(delegate { return inputStream;}, delegate { return new SpreadsheetLoadOptions();}))
    {
        //3. Let's create an intermediate EditableDocument from 1st tab
        SpreadsheetEditOptions editOptions1 = new SpreadsheetEditOptions();
        editOptions1.WorksheetIndex = 0;//index is 0-based
        EditableDocument firstTabBeforeEdit = editor.Edit(editOptions1);

        //4. Let's create an intermediate EditableDocument from 2nd tab
        SpreadsheetEditOptions editOptions2 = new SpreadsheetEditOptions();
        editOptions2.WorksheetIndex = 1;//index is 0-based
        EditableDocument secondTabBeforeEdit = editor.Edit(editOptions2);

        //5. Save first tab from EditableDocument #1 to separate document
        SpreadsheetSaveOptions saveOptions1 = new SpreadsheetSaveOptions(SpreadsheetFormats.Xlsm);
        string outputFilename1 = Path.GetFileNameWithoutExtension(inputFilePath) + "_tab1.xlsm";
        string outputPath1 = Path.Combine(Constants.GetOutputDirectoryPath(), outputFilename1);
        editor.Save(firstTabBeforeEdit, outputPath1, saveOptions1);

        //6. Save second tab from EditableDocument #2 to separate document
        SpreadsheetSaveOptions saveOptions2 = new SpreadsheetSaveOptions(SpreadsheetFormats.Xlsb);
        string outputFilename2 = Path.GetFileNameWithoutExtension(inputFilePath) + "_tab2.xlsb";
        string outputPath2 = Path.Combine(Constants.GetOutputDirectoryPath(), outputFilename2);
        editor.Save(secondTabBeforeEdit, outputPath2, saveOptions2);

        //7. Dispose both EditableDocument instances
        firstTabBeforeEdit.Dispose();
        secondTabBeforeEdit.Dispose();
    }
}