API sets for .NET to manipulate Excel tables
Create, edit, read, protect and print Excel spreadsheets, including more than 10 file formats – without installing Microsoft Excel
Aspose.Cells for .NET is an API for programmatic interaction with Excel spreadsheets, allowing software developers to manipulate and convert table files from applications developed by them. As a combination of different APIs and GUI controls, Aspose.Cells for .NET speeds up programming and migration from Microsoft Excel.
This Excel Spreadsheet API provides developers with a set of powerful tools for performing both simple file conversion operations and more complex tasks. Developers have control over page display, formatting, graphs, and formulas. They can read and write table files and upload them to a variety of graphic, text, and PDF file formats.
Aspose.Cells for .NET – fast and reliable. It saves you time and effort when compared to self-development of a table manipulation solution or automation from Microsoft.
Provides an overview of the main Excel file formats and the data processing, importing, and rendering capabilities provided by Aspose.Cells for .NET.
| Rendering | Aspose.Cells Control Sets | |
|
|
|
| Data processing | ||
|
Aspose.Cells for .NET supports popular file formats with spreadsheets (XLS, XLSX, XLSM, XLSB, XLTX, XLTM, CSV, SpreadsheetML, ODS) that are used by your business every day. It also exports data from Excel files to PDF, XPS, HTML, MHTML, Plain Text, and popular graphic image formats including TIFF, JPG, PNG, BMP, and SVG.
| ⇑⇓ Input/Output | Output only ⇑ | |
|
|
|
Aspose.Cells for .NET supports the .NET framework (including C#, VB.NET, ASP.NET, and so on.), PHP, Python, and Mono.
| Mono & COM Interop | Framework .NET | |
| PHP, VBScript, Delphi, C++ ⇒ |
|
⇐ ASP.NET Web Applications ⇐ Web services ⇐ Windows Applications |
Advanced API capabilities for processing Excel tables
Unlike similar products from other manufacturers, Aspose.Cells for .NET not only supports table generation and other basic features for uploading formatted content to a file, but also supports a number of advanced features. These advanced features allow developers to manipulate table content, cell formatting, and file protection much more easily. Aspose.Cells for .NET includes the following features:
| Ability to save and open Excel files from and from the stream | Send output to the client browser | Load and unload data from a DataTable, DataView, or Array |
| Import images and graphics | Create images and graphs via API | Import formulas from designed tables |
| Configure page settings via API |
It also supports a list of unique features that developers can only find in Aspose.Cells for .NET:
| CSV format supported | Office Open XML (OOXML) is supported | Add a copy of an existing worksheet (with full content, images and graphs, etc.) to a new file |
| Change the background background in the gradient for charts via API | Create comments | Using auto-filtering and tearing pages through the API |
| Using complex formulas | Conditional formatting is supported | Supports the protection options introduced in Microsoft Excel XP |
| Manipulating a Dynamic Named Range | Minigraphics MS Excel 2010 | Digital signatures |
| Support for custom API graphs | Formula Calculation Engine | Upload worksheets to SVG files |
| Read/write large tables in lite mode | In the process of converting Excel-to-PDF, redo images | Trace affected and dependent cells |
| Create and manipulate scripts | Modifying VBA or Macros Code in a Template File | Save ODS file in versions 1.1 and 1.2 of the ODF specifications |
| Optimize memory usage when processing large files through memory optimization options | And much more! |
Generate Excel spreadsheets on any platform and in any development environment
Aspose.Cells for .NET along with Aspose.Cells for Java covers the core development tools and platforms that exist today. You can confidently use Aspose.Cells for .NET to build any type of 32-bit and 64-bit .NET application, including ASP.NET, web services, and WinForms. The Aspose.Cells for .NET API is easily deployed without being bound to any other software (except for the need for the .NET framework itself).
It is also possible to use Aspose.Cells for .NET on technologies that precede .NET technologies (such as ASP) in the form of a COM Wrapper. You can also use it with C/C++, Mono, PHP, Python, etc.
Flexible options for displaying Excel worksheets
Aspose.Cells for .NET gives you full control over page preferences and allows you to manipulate a wide range of options for displaying Excel worksheets, such as previewing page breaks and zoom levels for a worksheet, controlling the visibility of data using the freeze panel, setting page orientation, stretching, page size, header, footer, and print area options, and so on.
Excel security options to protect worksheets
Aspose.Cells for .NET offers a wide range of security options, including support for securing an Excel 2007 XLSX file, protecting worksheet content, objects, and scripts, and the ability to hide and show worksheets.
Manipulate rows and columns in Excel spreadsheets
Aspose.Cells for .NET offers you the ability to manipulate rows and columns in a variety of ways. You can easily control the row height and column width if you want. You can set the automatic selection of the size of the height/width of the cell according to the content, insert and delete, hide and show, group and ungroup rows and columns.
Manage worksheet data
Aspose.Cells for .NET offers extensive support for data management. You can easily manipulate any cells of a worksheet in real time, import data into a worksheet from various sources, and export the data to a DataTable.
Comprehensive table formatting support
Aspose.Cells for .NET gives you absolute control over how you display data according to what advanced formatting options are offered. You can apply custom formatting to worksheets, rows, columns, and cells. You can also add formatted text to a single cell or apply different appearances to frames, backgrounds, and fonts. Cells can also be subject to conditional formatting.
Create charts in Excel
Aspose.Cells for .NET is provided with full support for graphics processing and supports all standard chart types. You can easily add custom charts using the API and dynamically define data for charts. Aspose.Cells for .NET also offers you the possibility to convert graphs into images.
Advanced graphics processing in Excel
Aspose.Cells for .NET provides advanced graphics capabilities, allows you to easily convert worksheets to images and add images to worksheets in real time.
Support for many file formats
Using Aspose.Cells for .NET, developers can easily open and save a variety of file formats, including:
- Excel 97/2000/XP/2003/2007/2010/2013 (XLS/XLSX)
- SpreadSheetML
- Tab Delimited
- CSV
- Office Open XML (OOXML) File Formats SpreadsheetML
Using Aspose.Cells for .NET, you can also open encrypted Excel files. And it’s even possible to convert Excel documents to PDF directly. Aspose.Cells for .NET also supports opening and saving to the Open Document Spreadsheet (ODS) file format.
Aspose.Cells Grid Suite
Aspose.Cells for .NET also provides GUI controls for desktop and web applications. The following features are supported:
- Desktop Control for Windows Forms Applications
- Web Controls for ASP.NET Web Forms Applications
- Apply formatting and formulas
- Import and export (DataTable, DataView)
- Open, save, and edit Excel files by using controls
Microsoft Office Automation Is No Longer Needed
Aspose.Cells for .NET is built on managed code that doesn’t require you to install Microsoft Office or Microsoft Excel on your computer to manage Excel documents. It is an ideal alternative to Microsoft Office automation in terms of supported features, security, stability, scalability, speed, and price.