Document Editor .NET API

Nuget

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 Processing Features

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 an HTML document along with all its resources (stylesheets, images).
Open any supported format file in HTML format and save it to disk.
Fetch HTML markup from DB or remote storage.

Supported File Formats for Editing

Document 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, POTM, ODP, OTP
Other: TXT, HTML, XML

Supported Formats for Auto-detection

Document 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, POTM, ODP, OTP

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
Mac OS: 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.Conversion for .NET supports .NET and Mono frameworks.

Get Started

Are you ready to give GroupDocs.Editor for .NET a try? Simply execute Install-Package GroupDocs.Editor from Package Manager Console in Visual Studio to fetch & reference GroupDocs.Editor assembly in your project. If you already have GroupDocs.Editor for .Net and want to upgrade it, please execute Update-Package GroupDocs.Editor to get the latest version.

Please check the GitHub Repository for other common usage scenarios.

Load, Edit & Save Multi-tab Spreadsheet via C# Code

//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 the 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();
  }
}