Manipulate Excel Workbooks using Cloud SDK

Android Cloud SDK to create, encrypt, merge, watermark & convert spreadsheets via SDK. Process charts, pivot tables, & formulas.

  Start Free Trial
Aspose.Cells Cloud SDK for Android

Aspose.Cells Cloud SDK for Android

 
 

Aspose.Cells Cloud SDK for Android integrates Excel spreadsheet processing functionality into your mobile Android Apps. This SDK is a wrapper around a robust set of Android Cloud REST APIs which seamlessly integrates into your spreadsheet manipulation Apps without the need to download or install any software.

Our Cloud SDK for Android makes spreadsheet management tasks significantly easy and scalable and offers basic to advanced Excel processing features, such as, creating spreadsheets, merging multiple sheets, encrypting/decrypting, and converting spreadsheets to save to various raster and fixed layout formats. You can also upload spreadsheets to cloud storage.

 

Advance Spreadsheet manipulation Features

 

 

Create spreadsheets from templates, XML or smart markers

 

Merge multiple spreadsheets

 

Split spreadsheets to single worksheet spreadsheets

 

Convert spreadsheets to different formats

 

Export worksheets to images

 

Protect & unprotect workbooks & worksheets

 

Encrypt & de-crypt spreadsheets

 

Hide & show worksheets

 

Trim Worksheet name at run-time

 

Create, manipulate & render charts

 

Import / Export images & charts

 

Create & manipulate conditional formatting rules

 

Extract charts, pictures, shapes & other objects as images

 

Manipulate rows, columns, cells & data

 

Add, Update, Delete OLE Objects

 

Autofit rows & columns

 

Dynamically create & manipulate Pivot Tables

 

Set complex formula

 

Reliable Formula calculation engine

 

Add & update text & images

 

Manipulate comments

Single SDK for all Popular Worksheet Formats

Aspose.Cells Cloud SDK for Android enables you to easily open and save a multitude of file formats. Some of the formats include XLS, XLSX, XLSB, XLSM, XLTX, XLTM, ODS, Tab delimited, CSV, TSV, TXT, PDF, SpreadsheetML, HTML and MHTML. The Office Open XML (OOXML) is a container format for several specialized XML-based markup languages. OOXML SpreadsheetML documents mostly come as XLSX files, which are ZIP packages. In addition to XLSX format, Aspose.Cells Cloud SDK for Android also offers extensive support for SpreadsheetML documents. For conversion purposes, the SDK offers the capabilities to render the output in either of the above formats or exclusively generate the output in PDF, PDF/A, XPS, JPEG, PNG, BMP, SVG, TIFF and EMF file formats.

Extensive Support for Worksheets Elements

Aspose.Cells Cloud SDK for Android provides a complete control over spreadsheets and the data inside them. The Excel cloud SDK enables the developers to perform operations 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. It also helps you to create formulas and make sophisticated calculations based on user input or external data sources. You may use it to work with individual cells in a spreadsheet, add comments, apply validation rules and manage hyperlinks & pictures. The SDK also allows manipulating all aspects of the spreadsheets including worksheets, rows, columns, cells, text, data, images, links, comments, charts and many more. Aspose.Cells Cloud SDK for Android puts all these features at your fingertips, through a cloud-based interface.

Visualize Data with Formatting, Charts & Graphics

Aspose.Cells Cloud SDK for Android gives you complete freedom and flexibility to furnish your spreadsheets with all kinds of visual effects. The SDK 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 Cloud SDK for Android provides a comprehensive support 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.

Summarize Data with Pivot Tables, Charts

Aspose.Cells Cloud SDK for Android llows you to manipulate spreadsheet data including text, numeric or alphanumeric with the help of simple methods. You can add, modify or remove data from cells as well as add and calculating formulas in a worksheet cell to get the resultant value. It also provides the capabilities to effectively summarize and display the data. A Pivot Table can help you quickly summarize the flat data and to get the desired information according to your needs. Aspose.Cells Cloud SDK for Android 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 Cloud SDK for Android offers Smart Markers which is a great feature to populate worksheets based on some data source and to create visually effective reports.

Add Pivot Field into Pivot Table - Android


StorageApi storageApi = new StorageApi(Configuration.apiKey, Configuration.appSID, true);
CellsApi cellsApi = new CellsApi(Configuration.apiKey, Configuration.appSID, true);

File inputFile = Utils.stream2file("sample7","xlsx", context.getResources().openRawResource(R.raw.sample7));
File outputFile = Utils.stream2file("sample2","xlsx", context.getResources().openRawResource(R.raw.sample2));
com.aspose.cells.model.PivotTableFieldRequest body = new com.aspose.cells.model.PivotTableFieldRequest();
body.getData().add(1);
body.getData().add(1);
storageApi.PutCreate("sample7.xlsx", null, Utils.STORAGE, inputFile);
cellsApi.PutPivotTableField("sample7.xlsx", "Sheet1", 0, "Row", Utils.STORAGE, Utils.FOLDER, body);
com.aspose.storage.model.ResponseMessage sr = storageApi.GetDownload("sample7.xlsx", null, Utils.STORAGE);
Utils.copyInputStreamToFile(sr.getInputStream(),outputFile);

Render Excel Worksheets & Charts as Images

Aspose.Cells Cloud SDK for Android 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 spreadsheets, Charts, AutoShapes and OleObjects to most commonly used image formats such as JPG, BMP, GIF, PNG etc while ensuring accuracy and precision, and as a result, majority of conversions will be indistinguishable from the original Spreadsheet files. Along with conversion feature, it also provides the feature of 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.

 

Support and Learning Resources