Aspose.Cells for .NET is a Spreadsheet component that allows .NET developers to embed the ability to read, write and manipulate Excel spreadsheets into their own applications without needing to rely on Microsoft Excel.
Aspose.Cells for .NET is a mature, scalable and feature rich component that offers many functions that are way beyond the simple data exporting capabilites of other vendors. With Aspose.Cells for .NET developers can export data, format spreadsheets to the most granular level, import images, import charts, create charts, apply and calculate complex formulas, stream Excel data, save in various formats and much more - all this without the need to use Microsoft Excel or Microsoft Office Automation.
Common Uses
Excel Reporting - Build dynamic Excel reports on the fly
Create Excel Dashboards, incorporating Charts and Pivot Tables
High-fidelity Excel Rendering and Printing
Import Data from Excel Spreadsheets
Export Data to Excel Spreadsheets
Spreadsheet Generation
Spreadsheet Visualization through an Excel enabled Grid for both Desktop and Web
Spreadsheet Manipulation / Editing
Spreadsheet Conversion
Key Features
No Microsoft Excel Automation
Aspose.Cells for .NET is an incredibly versatile component that allows developers to create, manage and manipulate Excel spreadsheets without requiring Microsoft Excel or Microsoft Office to be installed on the system. In short, Aspose.Cells for .NET is a better alternative to Office Automation in terms of security, stability, scalibility, speed, price and features.
Advanced Features
Unlike similar products from other vendors, Aspose.Cells for .NET not only supports spreadsheet generation and other basic file formatting features, it also supports a number of advanced features. These advanced features make it much easier for developers to manipulate spreadsheet contents, cell formatting and file protection. Aspose.Cells for .NET includes the following features:
Ability to save and open Excel files to and from streams
Send output to a client browser
Import and export data from a DataTable, DataView or Array
Import images and charts
Create images and charts through the product API
Import formulae from a designer spreadsheet
Configure page setup through the product API
Aspose.Cells for .NET also supports Addins, VBA and macros. As well as this, there are also a number of unique features that developers can only find in Aspose.Cells for .NET, these include:
Support of the CSV format
Support for Office Open XML (OOXML).
Add a copy of an existing worksheet (with full contents, images and charts etc.) to a new file
Set the gradient background for charts through the product API
Create comments
Auto-filters and page breaks through the product API
Set complex formulae
Support conditional formatting
Support protection options introduced in Microsoft Excel XP
Manipulate named ranges
MS Excel 2010 Sparklines
Locating APIs
Support custom chart API
Formula calculation engine
Platform Independence
Aspose.Cells for .NET together with Aspose.Cells for Java cover the main development environments and deployment platforms in common use today. You can confidently use Aspose.Cells for .NET to build any type of a 32-bit or 64-bit .NET application including ASP.NET, Web Services and WinForms. Aspose.Cells for .NET is easy to deploy because it is just a class library without any dependencies (except on the .NET Framework itself).
It is also possible to use Aspose.Cells for .NET in pre- .NET technologies (like ASP) as a COM Wrapper. You can also use the Aspose.Cells for .NET component with C/C++, Mono, PHP, Python etc.
Flexible Display Options
Aspose.Cells for .NET gives you complete control over page setup and allows you to manipulate a wide range of display options such as; preview page breaks and the zoom level for the Worksheet, control data visibility using Freeze Panes, set page orientation options, scaling, paper size, headers/footers, and print area etc.
Security features
Aspose.Cells for .NET offers a wide range of security features including; support for Excel 2007 XLSX file encryption/decryption, protect Contents, Objects and Scenarios of a Worksheet and the ability to hide and unhide a Worksheet.
Manipulate Rows and Columns
Aspose.Cells for .NET allows you to manipulate Rows and Columns in many different ways. You can easily adjust Row height and Column width as required, auto size the width/height of cells according to contents, insert and delete, hide and unhide as well as group and ungroup Rows and Columns.
Data Management
Aspose.Cells for .NET provides extensive support for data management. You can easily manipulate any Cell in a Worksheet at runtime, import data into Worksheets from different data sources and export data to a DataTable.
Comprehensive Formatting Support
Aspose.Cells for .NET gives you absolute control over how your data is presented by offering advanced formatting features. You can apply individual formatting to a Worksheet, Row, Column, and Cell. You can also add Rich Text to a Single Cell and apply different Borders, Background Patterns and Fonts. Conditional formatting can also be applied to Cells.
Creating Charts
Aspose.Cells for .NET comes with complete support for charting and supports all standard chart types. You can easily add customized charts using the product API and dynamically set data for charts. Aspose.Cells for .NET also allows you to convert charts to images.
Graphics Capabilities
Aspose.Cells for .NET provides extensive graphical capabilities, allowing you to easily convert Worksheets to images as well as adding images to Worksheets at runtime.
Support for many Different File Formats
Using Aspose.Cells for .NET, developers can easily open and save a multitude of file formats. These include
Excel 97 / 2000 / XP / 2007 / 2010 (XLSX)
SpreadSheetML
Tab Delimited
CSV
Office Open XML (OOXML) SpreadsheetML file formats
Using Aspose.Cells for .NET you can also open encrypted Excel files. It is even possible to convert Excel documents into PDF format directly using the component. Aspose.Cells for .NET also supports opening and saving of ODS(Open Document Spreadsheet) format files.
Support for Office Open XML (OOXML)
Office Open XML (OOXML) is a container format for several specialized XML-based markup languages. OOXML SpreadsheetML documents mostly come as XLSX files, which are ZIP packages. In addition to XLSX, Aspose.Cells for .NET provides extensive support for loading, saving and converting SpreadsheetML documents.
Aspose.Cells Grid Suite
Aspose.Cells for .NET also provides a complete Grid solution for the customers, it has two GUI based .NET controls:
Aspose.Cells.GridDesktop, that supports desktop applications.
Aspose.Cells.GridWeb , that supports web applications.