.NET APIs to manipulate Excel spreadsheets
Create, read, edit, convert, protect or print Excel spreadsheets including more than 10 file formats without installing Microsoft ExcelDownload Free Trial
Aspose.Cells for .NET
Aspose.Cells for .NET is an Excel Spreadsheet Programming API allowing software developers to manipulate and convert spreadsheet files from within their own applications. A combination of APIs and GUI controls - Aspose.Cells for .NET speeds up Microsoft Excel programming and conversion.
The Excel spreadsheet API gives developers powerful tools for performing simple file conversions or more complex tasks. Developers have control over page layout, formatting, charts and formulas. They can read and write spreadsheet files and save out to a variety of image, portable and text file formats.
Aspose.Cells for .NET is fast and reliable. It saves time and effort compared to developing your own spreadsheet manipulation solution or using Microsoft Automation.
At A Glance
An overview of the main Excel file formats, data processing, import, export and rendering capabilities of Aspose.Cells for .NET.
- Convert Chart to Image
- Convert Worksheet to Image
- Convert Spreadsheet to PDF
- Apply Formatting
- Create Charts
- Apply Formulas
- Smart Markers
- Desktop Control for WinForms
- Web Control for ASP.NET
- Apply Formatting
- Apply Formulas
- Import/Export Data
- Support for Excel 97-2010 File Formats
Aspose.Cells for .NET supports the .NET framework (including C#, VB.NET, ASP.NET etc.), PHP, Python and Mono.
- PHP, VBScript, Delphi, C++
- ASP.NET Web Application
- Web Services
- Windows Application
Supported File Formats
Aspose.Cells for .NET supports the popular spreadsheet (XLS, XLSX, XLSM, XLSB, XLTX, XLTM, CSV, SpreadsheetML, ODS) file formats your business use every day. It also allows exporting Excel files to PDF, XPS, HTML, MHTML, Plain Text and popular image formats including TIFF, JPG, PNG, BMP and SVG.
- Microsoft Excel: XLS, XLSX, XLSB, XLTX, XLTM, XLSM, XML
- OpenOffice: ODS
- Text: CSV, Tab-Delimited, TXT
- Web: HTML, MHTML
- Fixed Layout: PDF, PDF/A, XPS
- Images: JPEG, PNG, BMP, SVG, TIFF, EMF
Advanced Excel Spreadsheet API 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
It also supports a number of unique features that developers can only find in Aspose.Cells for .NET:
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
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
Support custom chart API
Formula calculation engine
Exporting worksheets to SVG files
Reading / writing large spreadsheets in light-weight mode
Re-sample images in Excel-to-PDF conversion
Tracing Precedents and Dependents
Create and manipulate Scenarios
Modify VBA code or Macros in the template file
Save ODS file in ODF 1.1 and 1.2 specifications
Optimize memory usage while working with large files via memory preference options
Many many more!
Generate Excel Spreadsheet in Any Platform – Any Development Environment
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 API is easy to deploy 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 it with C/C++, Mono, PHP, Python etc.
Flexible Excel Worksheet Display Options
Aspose.Cells for .NET gives you complete control over page setup and allows you to manipulate a wide range of Excel Worksheet 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.
Excel Security Options for Protecting Worksheets
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 within Excel Spreadsheets
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.
Worksheet 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 Spreadsheet 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 in Excel
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.
Extended Excel 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/2003/2007/2010/2013 (XLS/XLSX)
- Tab Delimited
- 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. Aspose.Cells for .NET also supports opening and saving of ODS (Open Document Spreadsheet) format files.
Aspose.Cells Grid Suite
Aspose.Cells for .NET also prodvides GUI controls for desktop and web applications. Following features are supported:
- Desktop Control for Windows Forms Applications
- Web Control for ASP.NET Web Forms Applications
- Apply Formatting and Formulae
- Import and Export (DataTable, DataView)
- Open, save and edit the Excel files using the control
Microsoft Office Automation – Not Needed
Aspose.Cells for .NET is built using managed code that never needs Microsoft Office or Microsoft Excel to be installed on the machine to work with Excel document formats. It is a perfect Microsoft Office automation alternative in terms of supported features, security, stability, scalability, speed and price.