Aspose.Cells for iOS via Xamarin Features

Aspose.Cells for iOS via Xamarin Features Overview

This section provides a comparison of availability of features between Aspose.Cells for .NET and Aspose.Cells for iOS via Xamarin.

File Formats and Conversions

Many customers worldwide rely on the thorough document import and export features provided by Aspose.Cells.

Feature Description .NET Xamarin.iOS
High-Quality Conversions Quickly and reliably, convert between several popular document formats. tick tick
Microsoft Excel Workbook (XLS) The fastest and most complete XLS format implementation you can find. tick tick
SpreadsheetML (XLSX, XML) Aspose.Cells supports OOXML, Flat OPC and also Excel 2003 XML. Moreover,
the component supports all major Excel 2007, 2010 and 2013 file formats e.g XLSX, XLTX, XLSM, XLTM etc.
tick tick
Comma Separated Value (CSV) Comprehensive support of the CSV format to interact with a variety of applications. tick tick
HTML Save as HTML is available. tick tick
OpenDocument (ODS) Aspose.Cells can load and save documents in the OpenDocument Spreadsheet (.ods) format. tick tick
Adobe Portable Document Format (PDF) Convert any Spreadsheet to PDF with high fidelity. tick tick
Tab Delimited Load and save documents in the tab delimited file format. tick tick
Plain Text (TXT) Easily extract text by saving in plain text format. tick tick

Spreadsheet Content Features

Aspose.Cells provides a rich object model that consists of over 100 public classes/interfaces, which allow you to programmatically generate, combine, modify, parse or otherwise examine loaded spreadsheets. Some key features are given in the below table.

Feature .NET Xamarin.iOS
Import/export data from an Array, ArrayList, ResultSet etc. tick tick
Add a copy of existing worksheet (all contents including images, charts, other objects etc.) tick tick (Images and charts are not supported)
Copy or move worksheets within or between workbooks tick tick
Insert images tick circle
Create charts tick circle
Set gradient background for charts using API tick circle
Add comments to cells tick circle
Microsoft Excel 2007 themes and colors tick tick
Create auto-filters tick tick
Implement data validations tick circle
Implement data sorting tick tick
Find and replace text tick tick
Merge/split Cells tick tick
Group/ungroup rows and columns tick tick
Create custom page breaks tick circle
Insert/delete or hide rows, columns and sheets tick tick
Calculate complex Excel formulae tick tick
Support advanced conditional formatting supported in Microsoft Excel 2007 tick tick
Freeze/unfreeze Panes tick tick
Insert hyperlinks to link data tick tick
Implement Smart Markers tick circle
Specify document properties settings tick tick
Protect/unprotect worksheets tick circle
Specify advanced protection options introduced in Excel XP and later versions tick circle
Create list object/Microsoft Excel tables tick tick
Create subtotals tick tick
Insert form controls and other drawing shapes/objects tick circle
Create pivot tables and pivot charts tick circle
Preserve or remove addin, VBA, macros tick circle
Manipulate named ranges tick tick
Create custom charts tick circle
Add, preserve or extract OLE objects from the spreadsheets. tick circle
Implement Microsoft Excel 2010 sparklines tick circle
Encrypt files tick circle

Spreadsheet Formatting Features

Aspose.Cells provides detailed programmatic access to formatting properties of all spreadsheet elements.

Feature .NET Xamarin.iOS
Apply all characters formatting in the cells including fonts, colors, effects, borders and shading. tick tick
Apply all the number format settings (supported in Microsoft Excel) for the cells. tick tick
Set all types of text alignment settings. tick tick
Apply different kinds of Font Settings for the cells. tick tick
Apply different colors to cells, fonts, gridlines, graphic objects etc. tick tick (Graphic objects are not supported)
Apply different rich text formatting in a single cell. tick tick
Apply different border settings on cells. tick tick
Apply different background patterns on cells. tick tick
Apply Format settings on a worksheet, row, column or a range of cells etc. tick tick

PageSetup Features

You can use Aspose.Cells to implement page setup options for worksheets.

Feature .NET Xamarin.iOS
Adjust your page orientation, scaling, paper size. tick tick
Specify your margins and page centering. tick circle
Create or edit your header and/or footer. tick circle
Set print area, print titles, or turn on gridlines etc. tick tick