.NET APIs to manipulate Excel spreadsheets
Develop high performance applications to Create, Edit, Convert or Print Excel spreadsheet file formats without requiring Microsoft Excel.Download 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 the Microsoft Excel programming and conversion tasks.
Aspose.Cells for .NET gives developers powerful tools for performing simple tasks such as file format conversion or complex processes like report generation through Smart Markers. It also gives the developers full control over the page layout, formatting, charts and formulas. Developers can read and write spreadsheet files as well as render the spreadsheets to a variety of image & fixed-layout file formats.
At A Glance
An overview of Aspose.Cells for .NET capabilities.
- 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 file formats as well as mostly commonly used image & fixed-layout formats.
- 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
Aspose.Cells for .NET includes the following features:
Ability to save and load Excel files to and from streams
Send output to a client browser
Import and export data to and from DataTable, DataView or Array
Configure page setup through the product API
Create charts through the product API
Import formulae from a designer spreadsheet
Aspose.Cells for .NET also supports a number of unique features that developers can only find in this API:
Support for CSV, Tab-delimited & HTML formats
Support for Office Open XML (OOXML) formats
Create copies of existing worksheets
Set the gradient background for charts
Create & manipulate comments
Set auto-filters & page breaks
Set complex formulae
Specify conditional formatting rules
Set protection options introduced in Microsoft Excel XP
Create & manipulate named ranges
Create & render sparklines
Add Digital Signatures
Create & render custom charts
Formula calculation engine
Export worksheets to SVG format
Read & write large spreadsheets in light-weight mode
Re-sample images in Excel-to-PDF conversion
Trace 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
Populate spreadsheets via Smart Markers
Dynamically create & manipulate Pivot Tables
Visualize Data with Formatting, Charts & Graphics
Aspose.Cells for .NET gives you complete freedom and flexibility to furnish your spreadsheets with all kinds of visual effects. The API allows you to apply different fonts with attributes, cell styles (alignment, indentation, rotation, borders, shading and coloring, protection, text wrapping and shrinking) and all types of number formats.
Similarly, charts and graphics are visually appealing and can give your spreadsheet a professional look. Aspose.Cells for .NET provides a comprehensive set of APIs for creating and manipulating all of the standard and custom chart types. Moreover, you may add different types of drawing objects, such as comments, pictures, OLE objects, shapes and controls to the cells
Convert Excel Spreadsheets & Objects to Images & PDF
Aspose.Cells for .NET has its own rendering engine specially designed for rendering & printing with highest of fidelity to the Microsoft Excel. Developers find it easy to print or preview spreadsheets from within their own applications, this is due to Aspose.Cells for .NET's integration with the .NET printing infrastructure and the ability to customize the conversion process.
Aspose.Cells for .NET also offers distinctive features such as converting charts to images & PDF, converting worksheets to images, printing worksheets and converting spreadsheets to PDF file format. The conversion process is greatly flexible thus allowing you to choose a number of options for the conversion, such as re-sampling of images while converting spreadsheets to PDF or controlling the resultant image dimensions when rendering worksheets & charts to images.
Efficient, Robust & Reliable Formula Calculation Engine
Aspose.Cells for .NET has a powerful Formula Calculation Engine that supports almost all of the standard and advanced Microsoft Excel formulas and functions. You can read, set and calculate the results of the built-in, add-in, array & R1C1 reference style formulas.
Easily Summarize Data with Pivot Tables, Charts & Smart Markers
A Pivot Table can help you quickly summarize the flat data and to get the desired information according to your needs. Aspose.Cells for .NET allows you to create Pivot Tables and Pivot Charts programatically. You can dynamically change the source data of a Pivot Table and refresh it. Moreover, Aspose.Cells for .NET offers Smart Markers which is a great feature to populate worksheets based on some data source and to create visually effective reports.
Chart Creation & Manipulation
Aspose.Cells for .NET comes with complete support for charting. You can easily add standard or customized charts using the product API, and dynamically set the data in order to refresh the charts. Aspose.Cells for .NET also allows you to convert charts to a number of image formats.
Graphical Interfaces for Web & Desktop Applications
Aspose.Cells for .NET provides GUI controls for web & desktop applications. End user can use these controls to open, save & edit Excel files, import & export data, manage formatting & formulas and convert between several supported spreadsheet formats, right from your application's front-end.
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.