Aspose Aspose.Cells for .NET
Aspose.Cells for .NET

Aspose.Cells for .NET

Aspose.Cells for .NET provides developers with the functionality to programmatically interface with the Excel file format in .NET, iOS, and Android applications without requiring Microsft Excel. XLS, XLSM, XLSX, XLTX/XLTM, CSV, HTML, ODS, Tab Delimited & SpreadsheetML, and other major Microsoft Excel formats are supported in Aspose.Cells for .NET.

Aspose.Cells for .NET Developer Small Business - Single Developer, Single Location License type: Developer, .NET
£925.00
Aspose.Cells for .NET Developer OEM - Single Developer, Unlimited Deployment License type: Developer, .NET
£2,770.00
Aspose.Cells for .NET Site Small Business - Up to 10 Developers, 10 Location Deployment License type: Developer, .NET
£4,615.00
Aspose.Cells for .NET Site OEM - Up to 10 Developers, Unlimited Deployment License type: Developer, .NET
£12,915.00

Overview

Aspose.Cells for .NET is a Spreadsheet Programming API that helps developers automate spreadsheet processing and management tasks. Developers can build cross-platform applications with the functionality to Render, Generate, Modify, Convert, and Print spreadsheets. The key USP of Aspose.Cells for .NET is it does not require Microsoft’s spreadsheet management component MS Excel or MS Office Interop components.
Managing multiple worksheets, adding common and complex Mathematical, Financial, and Text formulas, manipulating charts, creating spreadsheet styles and content from scratch, importing data onto the worksheets from different data sources, drawing objects, pictures, and comments can be achieved via the Aspose.Cells API.

Aspose.Cells Input and Output Fomats

  • Microsoft Excel: XLS, XLTX, XLTM, , XLSX, XLSB, XLT , XML, XLSM
  • Text: CSV, TSV
  • OpenOffice: ODS
  • Numbers: Apple’s iWork Numbers app documents
  • Web: HTML, MHTML

Aspose.Cells Output Formats

  • Fixed Layout: PDF, XPS, PDF/A
  • Images: JPEG, SVG, PNG, BMP, TIFF, EMF, GIF
  • Data Interchange: DIF
  • Convert Spreadsheets to XPD, PDF & HTML 

Use Aspose.Cells for .NET to convert spreadsheets to XPS, PDF HTML formats, and maintain the sharpest fidelity. The conversion process is straightforward and can be achieved with only a few lines of code. This makes the Aspose.Cells API the perfect choice for organisations looking to dynamically exchange Spreadsheet document formats.

Visualise Data with Charts, Graphics and Formatting

The Aspose.Cells for .NET API allows developers to apply different fonts with attributes, cell styles (alignment, indentation, shading and coloring, rotation, borders, protection, text wrapping, and shrinking), and all types of number formats. This gives developers to manage all visual aspects of a spreadsheet.
Additional features of the component include manipulating and creating standard and custom chart types adding various types of drawing objects, pictures, OLE objects, comments, shapes, and controls 

Robust, Reliable & Efficient  Formulae Manipulation Engine

Spreadsheet Formulae manipulation is fully supported by Aspose.Cells for .NET powerful Formulae Computation Engine. The engine supports advanced MSExcel formulae and functions. Developers are able to set and calculate the results of the built-in, read, add-in, R1C1 reference style & array formulae.

Summarise Data containing Pivot Tables, Smart Markers & Charts

Pivot Tables help developers summarise Spreadsheet data to make information intelligible by dynamically creating Pivot Tables and Charts. Data sources are also accessible in real-time via the API. Smart Markers used to populate worksheets based on multiple data sources create visually informative reports is an integral feature of Aspose.Cells for .NET.

Render Images from Excell Worksheets & Charts

Aspose.Cells for .NET has a native rendering engine for rendering & printing with the highest fidelity from Microsoft Excel. Some of the features include rendering Excel worksheets & charts to images and printing worksheets to any connected or networked printer. 

Chart Manipulation and Creation

The Aspose.Cells for .NET API includes support for dynamic charting. Developers can add standard or customised charts using the API and dynamically set chart data. The API also allows developers to convert charts to multiple image formats.

GUIs for Desktop  & Web Applications

Aspose.Cells for .NET provides Graphical User Interface controls for desktop & web applications. Developers can use these controls to build bespoke interfaces for End-Users to open, save & edit Excel files, import & export data, manage formatting & formulas and convert between several supported spreadsheet formats.

Features

Send output to a client browser
Import/export data to & from DataTable, DataView or Array
Add & manipulate charts & PivotTable through the product API
Import formulas from a designer spreadsheet
Truncate long sheet name & replace invalid characters at run-time
Apply text alignment to partial text inside the TextBox
Paste rows & columns with advanced paste options
Support for CSV (comma-separated values) & TSV (tab-separated values)
Create & manipulate comments
Set auto-filters & page breaks
Specify conditional formatting rules
Create & manipulate named ranges
Create & render sparklines
Export worksheets to SVG format
Read & write large spreadsheets in light-weight mode
Re-sample images in Excel-to-PDF conversion
Modify VBA code or Macros in the template file
Populate spreadsheets via Smart Markers