Visual Document Editor for .NET Applications
Enhance your apps to edit documents, spreadsheets, DSV & XML for a wide range of file formats.
Document Editing via C# / VB.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 it to disk.
- Fetch HTML markup from DB or remote storage.
New Features & Enhancements v20.1.1
- This release offers some minor bug fixes.
Please visit GroupDocs.Editor for .NET 20.1.1 Release Notes for the detailed notes.
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
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
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();
}
}
Product Page | Docs | Demo | API Reference | Examples | Blog | Free Support | Temporary License