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 spreadsheet processing and conversion tasks.
Aspose.Cells for .NET contains APIs to be used with .NET Framework, .NET Core & Xamarin platform, empowering you to build cross-platform applications having the ability to generate, modify, convert, render and print spreadsheets without using Microsoft Excel.
An overview of Aspose.Cells for .NET capabilities.
Convert Chart to Image
Convert Worksheet to Image
Convert Spreadsheet to PDF
Printing
Apply Formatting
Create Charts
Apply Formulas
Summarize
Smart Markers
Desktop Control for WinForms
Web Control for ASP.NET
Apply Formatting
Apply Formulas
Import/Export Data
Aspose.Cells for .NET includes the following features:
Ability to save & load Excel files to & from streams
Send output to a client browser
Import & export data to & from DataTable, DataView or Array
Configure page setup through the product API
Create charts through the product API
Import formulas 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 (comma-separated values) & TSV (tab-separated values)
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 & calculate complex formulas
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