Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
Product Overview - Aspose.Cells for Android via Java
Contents
[
Hide
]
Welcome to the Aspose.Cells for Android via Java documentation!
Aspose.Cells is a flexible component that enables Android applications to create and manage Excel spreadsheets without requiring Microsoft Excel installed on the system. Unlike similar products from other vendors, Aspose.Cells not only supports spreadsheet generation and other basic file formatting features, but also a number of advanced features. These advanced features make it easy for developers to manipulate spreadsheet contents, cell formatting, and file protection. Aspose.Cells also allows you to import data into spreadsheets from different data sources, add common and complex mathematical, date and time, financial, or text formulas and functions. It further supports manipulating charts, pictures, comments, drawing objects, and controls.
Document Features
- Open plain or encrypted Excel files (Excel97 - Excel2007 and later versions) from different sources
- Save Excel files (Excel97 - Excel2007 and later versions) in different formats (XLS, XLSX/XLSM, XLTX, XLTM, XLSB, CSV, SpreadsheetML, Tab Delimited, HTML, etc.)
- Convert Excel file to PDF document
- Convert Excel spreadsheet to XPS document
- Read and write OpenDocument Spreadsheet (ODS) format
- Modify the document properties of Excel files
Worksheet Features
Display Options
- Hide or show a worksheet
- Show or hide tabs, scroll bars, gridlines, and row and column headers.
- Preview page breaks.
- Set a worksheet’s zoom level.
- Make selected data remain visible while scrolling using freeze panes.
Worksheet Protection
- Protect worksheet contents, objects, and scenarios.
Page Setup Options
- Set page orientation, scaling, paper size, and print quality.
- Set page margins for the top, left, right, and bottom.
- Set headers and footers.
- Set print area and print title.
Page Breaks
- Insert horizontal and vertical page breaks at a specified cell.
Rows & Columns Features
- Adjust the column width.
- Auto-size the width and height of cells.
- Add or delete rows and columns.
- Hide or show rows and columns.
- Group or ungroup rows and columns.
Data Management Features
- Add data to desired cells at runtime
- Import data into Worksheets from different data sources
- Retrieve data from cells according to their data types
- Export cell data to an array
- Find or search specific data in cells
- Set Formulae with Built-in or Add-in Functions
- Add different kinds of hyperlinks
- Create or access named ranges
- Apply Data Validation and Auto-Filtering
- Apply Subtotals to worksheet tables
Formatting Features
- Apply Number Format Settings to the cells
- Format cell as a date
- Set Text Alignment
- Merge multiple cells into a single one
- Apply different kinds of Font Settings to the cells
- Apply different colors to cells, fonts, gridlines, graphic objects, etc.
- Set Rich Text in a single cell
- Apply different Border Settings to cells
- Apply different Background Patterns to cells
- Apply Format Settings to a worksheet, row, or column, etc.
- Apply Conditional Formatting to cells
Charting & Graphics Features
- Create different kinds of charts easily
- Customize charts by setting various properties
- Set data for the charts dynamically
- Add custom charts to worksheets using the API
- Add pictures to worksheets at runtime
- Create and add comments to cells
- Convert charts to image files
- Convert worksheets to image files
Advance Features
- Supports Formula Calculations using a robust formula calculation engine
- Change source data of a PivotTable at runtime
- Create and manipulate PivotTables