Create, read, write or manipulate Excel files within Android apps without any dependencies.
Vendor
Aspose
Company Website
Aspose.Cells for Android via Java is a scalable and feature-rich Android spreadsheet API that enables developers to programmatically generate, combine, modify, and parse spreadsheets directly within Android applications. The API provides a wide range of capabilities, including Excel document formatting, page setup operations, data import/export, chart creation, formulas, worksheet rendering, and conversion to multiple formats. Aspose.Cells for Android via Java supports major Excel formats such as XLS, XLSX, XLSB, XLTX, XLTM, XLSM, XML, CSV, TSV, TXT, HTML, MHTML, ODS, as well as fixed‑layout formats like PDF, PDF/A, and XPS, and image formats including JPEG, PNG, BMP, SVG, and EMF. The library allows developers to apply formatting at granular levels—worksheet, row, column, cell, and ranges. It supports encryption/decryption, numbers formatting, comments, auto‑filters, page breaks, worksheet copying, protection options from Excel XP onward, conditional formatting, named ranges, scenarios, and tracing precedents and dependents. It also offers comprehensive chart and Pivot Table capabilities, powerful formula calculation, and seamless conversion of spreadsheets, worksheets, and charts to various image and document formats.
Features
- Worksheet & Cell Formatting: Apply formatting to worksheets, rows, columns, cells, and ranges.
- Data Import & Export: Import/export data from ArrayList, arrays, Recordset, and ResultSet.
- File Encryption: Encrypt and decrypt Excel files for secure document handling.
- Number Formatting: Set number formats for precise data representation.
- Charts Support: Create and manipulate charts programmatically.
- Comments Management: Create and edit comments inside worksheets.
- Formula Engine: Read, set, and calculate formulas, including built‑in, add-in, array, and R1C1 styles.
- Page Setup Configuration: Configure page layout and setup parameters.
- Auto‑Filters & Page Breaks: Set and manipulate filters and apply page breaks.
- Conditional Formatting: Create and customize conditional formatting rules.
- Worksheet Duplication: Create copies of existing worksheets.
- Protection Options: Apply and manage protection options introduced since Excel XP.
- Cells & Named Ranges: Manipulate cells and named ranges.
- Excel‑to‑PDF Conversion: Convert Excel files to PDF format while preserving fidelity.
- Image Rendering: Convert worksheets and charts to images (PNG, JPEG, BMP, SVG, EMF).
- Pivot Tables: Create and manipulate Pivot Tables.
- Custom Charts: Create and modify custom chart types.
- Trace Dependencies: Trace precedents and dependents for formula auditing.
- Scenarios Support: Create and manipulate Excel scenario models.
- Multi‑Format Read/Write: Read and write TSV, CSV, HTML, and other formats.
Benefits
- No Excel Dependencies: Works fully without Microsoft Excel or external libraries.
- Full Excel Feature Coverage: Supports advanced Excel features including charts, formulas, Pivot Tables, and conditional formatting.
- Reliable Conversions: Converts spreadsheets to PDF, XPS, HTML, and images with high visual fidelity.
- Mobile‑Optimized: Designed specifically for Android environments for efficient processing.
- Flexible Rendering: Supports worksheet and chart rendering with control over resolution, size, and image quality.
- Powerful Formula Engine: Calculates complex formulas with high accuracy, supporting Excel’s full formula set.
- High Scalability: Handles large datasets and complex spreadsheets in mobile environments.
- Wide Format Support: Covers all commonly used Excel, text, web, and fixed-layout formats.