Aspose.Cells for .NET v19.5.0 + Xamarin Edition
Aspose.Cells for .NET v19.5.0 + Xamarin Edition
Create, Read, Write and Save Excel file formats as well as Export spreadsheets to various data sources without any Microsoft Excel dependencies. Aspose.Cells for .NET is an Excel Spreadsheet Programming API to speed up the spreadsheet management and processing tasks. API supports to build cross-platform applications having the ability to generate, modify, convert, render and print spreadsheets. Moreover, It does not rely on Microsoft Excel or any Microsoft Office Interop components to be installed but a robust set of APIs that deal with all Excel formats as well as CSV and SpreadsheetML formats.
By integrating API, some of the basic tasks developers can perform like managing multiple worksheets, creating spreadsheet contents and styles from scratch, importing data onto the worksheets from different data sources, adding common and complex Mathematical, Financial and Text formulas, manipulation of charts, pictures, comments, drawing objects and much more.
Microsoft Excel: XLS, XLSX, XLSB, XLT, XLTX, XLTM, XLSM, XML
Text: CSV, TSV
Web: HTML, MHTML
Numbers: Apple's iWork office suite Numbers app documents
Fixed Layout: PDF, PDF/A, XPS
Data Interchange: DIF
Images: JPEG, PNG, BMP, SVG, TIFF, EMF, GIF
Advanced Excel Spreadsheet API 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 Import JSON files Configure page setup through the product API Create charts through the product API Import formulas from a designer spreadsheet Encrypt / Decrypt ODS files Support parsing formulas of revision logs to binary array Retrieve Subtotaling settings Skip column name with flag while exporting a range Export custom document properties to PDF File Get XML path from List Object / Table Truncate long sheet name & Replace invalid characters at run-time Retrieve query table result range Apply text alignment to partial text inside the TextBox Content Copying for accessibility Disable Pivot Table Ribbon Pasting rows / columns with advanced paste option 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 Sort by cell background color 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 Support cutting and pasting cells
Convert Spreadsheets to PDF, XPS & HTML Formats
Aspose.Cells for .NET is capable of converting spreadsheets to PDF, XPS & HTML formats while maintaining the highest visual fidelity. The conversion process is simple yet reliable, thus making Aspose.Cells a perfect choice for the organizations which require to exchange documents in any of the industry standard formats.
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
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.
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 dynamically create Pivot Tables and Pivot Charts. 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.
Render Excel Worksheets & Charts as Images
Aspose.Cells for .NET has its own rendering engine specially designed for rendering & printing with highest of fidelity to the Microsoft Excel. It offers distinctive features such as rendering Excel worksheets & charts to images & printing worksheets to any connected physical printer. The process is flexible thus allowing you to choose a number of options, such as controlling the resultant image dimensions when rendering worksheets & charts to images.