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.