Aspose.Cells for Android是一款可擴(kuò)展并且功能豐富的組件。有了它，開發(fā)人員能導(dǎo)出數(shù)據(jù)，格式化電子表格到最精細(xì)的水平，導(dǎo)入圖像、圖表，創(chuàng)建圖表、應(yīng)用和計算復(fù)雜公式，保存為各種格式。

總覽：

Aspose.Cells for Android一些先進(jìn)的功能。

平臺獨立性

下圖簡明展示了Aspose.Cells for Android如何在各平臺上被使用。

支持的文件格式

Aspose.Cells for Android支持你的日常業(yè)務(wù)所需的流行的電子表格（XLS、XLSX、XLSM、CSV、SpreadsheetML）和HTML文件格式。

常見用途

• 讀和寫MS Excel文件格式，包括XLS、XLSX、XLSM、SpreadsheetML、CSV、Tab Delimited一級HTML。

• 應(yīng)用格式化（樣式）到工作表、行、列、單元格等。

• 加密/解密Excel文件。

• 通過產(chǎn)品API創(chuàng)建和操作圖表。

• 通過產(chǎn)品API插入圖像和創(chuàng)建評論。

• 在電子表格中讀取、設(shè)置和計算公式。

• 通過產(chǎn)品API配置頁面設(shè)置。

• 添加現(xiàn)有工作表的副本（以完整的內(nèi)容包括格式、圖像和圖表等）到新文件中。

• 應(yīng)用自動過濾器并插入分頁符到工作表中。

• 讀取和寫入條件格式。

• 支持MS Excel XP以來的保護(hù)選項。

• 操作單元格和指定范圍。

• 通過產(chǎn)品API創(chuàng)建和操作數(shù)據(jù)透視表

高級功能

不像來自其他供應(yīng)商的簡單產(chǎn)品，Aspose.Cells for Android不僅僅支持生成電子表格和其它基本文件格式化功能，它還支持另外一些高級功能，這些功能使開發(fā)人員更容易操控電子表格內(nèi)容、單元格格式和文件保護(hù)。Aspose.Cells for Android包括如下功能：

• 從（或到）stream中保存和打開Excel文件。

• 發(fā)送輸出到客戶瀏覽器。

• 從一個Array（數(shù)組）、ArrayList（數(shù)組列表）和Recordset中導(dǎo)入和導(dǎo)出數(shù)據(jù)。

• 導(dǎo)入圖像和圖表。

• 通過產(chǎn)品API創(chuàng)建圖像和圖表。

• 從電子表格導(dǎo)入公式。

• 通過產(chǎn)品API配置頁面設(shè)置。

靈活的顯示選項

Aspose.Cells for Android讓你完全掌控頁面設(shè)置并能夠操控大范圍的顯示選項，諸如：預(yù)覽分頁符和設(shè)置工作表的默認(rèn)縮放級別，用凍結(jié)窗格、設(shè)置頁面方向、紙張大小、標(biāo)題/頁腳以及打印區(qū)域等等來控制數(shù)據(jù)可見性。

安全特性

Aspose.Cells for Android 提供了大量安全特性，比如支持Excel 2007 XLSX文件加密和解密，保護(hù)工作表的內(nèi)容、對象和腳本，隱藏（取消隱藏）工作表等。

操作行與列

Aspose.Cells for Android 允許你從各種途徑操作行與列。你可以輕松調(diào)整行高度和列寬度，依據(jù)內(nèi)容自動調(diào)整單元格寬高，插入或刪除，隱藏或取消隱藏，編組或取消編組行與列。

全面的格式支持

Aspose.Cells for Android通過提供高級的格式功能，在數(shù)據(jù)表現(xiàn)上給你絕對的掌控。你可以應(yīng)用格式化到工作表、列、行和單元格。你還可以添加豐富的文本到單個單元格并應(yīng)用不同的邊界、背景模式和字體。條件格式化可以被用于單元格。

創(chuàng)建圖表

Aspose.Cells for Android 帶來對所有標(biāo)準(zhǔn)圖表類型的完全支持。你可以用產(chǎn)品API和動態(tài)設(shè)置數(shù)據(jù)來輕松添加自定義圖表。

支持多種文件格式

使用Aspose.Cells for Android，開發(fā)人員可以輕松打開并保存大量文件格式，包括：

•  Excel 97 / 2000 / XP / 2003 / 2007 / 2010 (XLSX/XLSM)

• SpreadSheetML

• Tab Delimited

• CSV

• Tab Delimited

• HTML

Aspose.Cells for Android is a scalable and feature rich component that offers many functions that are way beyond the simple data exporting capabilities of other vendors. With Aspose.Cells for Android developers can export data, format spreadsheets to the most granular level, import images, import charts, create charts, apply and calculate complex formulas, stream Excel® data, save in various formats and much more - all this without the need of Microsoft Excel®.

At A Glance

Some of the many advanced capabilities of Aspose.Cells for Android.

Platform Independence

This diagram highlights how Aspose.Cells for Android can be used on a variety of platforms.

Supported File Formats

Aspose.Cells for Android supports the popular spreadsheet (XLS, XLSX, XLSM, XLTX, XLTM, XLSB, CSV, SpreadsheetML, ODS), PDF, HTML, MHTML and image file formats that your business needs every day.

Common Uses

• Read and write MS Excel file formats including XLS, XLSX, XLSM, SpreadsheetML, Tab Delimited, CSV, Tab Delimited and HTML
• Ability to apply formatting (styles) to a Worksheet, Row, Column, Cell, Range etc.
• Import and export data from and to an Array, ArrayList and Recordset / Resultset
• Encrypt and decrypt Excel files
• Support numbers formatting
• Create and manipulate charts through product API
• Insert images and create comments through the product API
• Read, set and calculate formulae in the spreadsheets
• Configure page setup through the product API
• Add a copy of an existing worksheet (with full contents including formatting, images and charts etc.) to a new file
• Apply auto-filters and insert page breaks in the worksheet
• Read and write conditional formatting
• Support protection options introduced in since Microsoft Excel XP
• Manipulate cells and named ranges
• Create and manipulate PivotTables through the product API

Advanced Features

Unlike similar products from other vendors, Aspose.Cells for Android not only supports spreadsheet generation and other basic file formatting features, it also supports a number of advanced features. These advanced features make it much easier for developers to manipulate spreadsheet contents, cell formatting and file protection. Aspose.Cells for Android includes the following features:

• Ability to save and open Excel files to and from streams
• Send output to a client browser
• Import and export data from an Array, ArrayList and Recordset
• Import images and charts
• Create images and charts through the product API
• Import formulae from a designer spreadsheet
• Configure page setup through the product API

Flexible Display Options

Aspose.Cells for Android gives you complete control over page setup and allows you to manipulate a wide range of display options such as; preview page breaks and set default zoom level for the Worksheet, control data visibility using Freeze Panes, set page orientation, scaling, paper size, headers/footers, and print area etc.

Security features

Aspose.Cells for Android offers a wide range of security features such as; support for Excel 2007 XLSX file encryption and decryption, protect Contents, Objects and Scenarios of a Worksheet and hide or unhide a Worksheet.

Data Management

Aspose.Cells for Android provides extensive support for data management. You can easily manipulate any Cell in the Worksheet at runtime, import data into Worksheets from different data sources and export cells data to a DataTable.

Manipulate Rows and Columns

Aspose.Cells for Android allows you to manipulate Rows and Columns in many different ways. You can easily adjust Row height and Column width as required, auto size the width/height of cells according to contents, insert or delete, hide or unhide and group or ungroup Rows and Columns.

Creating Charts

A spose.Cells for Android comes with complete support for charting and supports all standard chart types. You can easily add customized charts using the products API and dynamically set data for the charts.

Support for many Different File Formats

Using Aspose.Cells for Android, developers can easily open and save a multitude of file formats. These include:

• Excel 97 / 2000 / XP / 2003 / 2007 / 2010 (XLSX/XLSM)
• SpreadSheetML
• Tab Delimited
• CSV
• Tab Delimited
• HTML