Java SDK for Spreadsheet Processing in the Cloud

Product Page | Documentation | Live Demo | Swagger UI | Code Samples | Blog | Free Support | Free Trial

Aspose.Cells Cloud SDK for Java helps you work with spreadsheet (Excel® & OpenOffice®) file formats within your cloud-based Java Apps, without installing any 3rd party software. It is a wrapper around Aspose.Cells Cloud REST APIs.

Cloud Spreadsheet Processor in a Nutshell

• Create new spreadsheets using Excel® files as templates or Smart Marker.
• Load & process Excel® spreadsheets & worksheets via Cloud SDK.
• Merge or split workbooks.
• Protect or unprotect worksheets.
• Import data to worksheets.
• Calculate formulas or add/update formulas to worksheet cells.
• Add, update or delete charts, worksheets, images, shapes, hyperlinks & validations.
• Add or remove cells area, conditional formatting or OleObjects from Excel® worksheets.
• Insert or delete horizontal or vertical page breaks
• Add ListObject at a specific place within an Excel® file & convert to a range of cells.
• Delete specific or all ListObjects in a worksheet or summarize data with Pivot Table.
• Apply custom criteria to list filters of various types.
• Get, update, show or hide chart legend & titles.
• Manipulate page setup, header & footer.
• Create, update, fetch or delete document properties.
• Fetch the required shape from worksheet.
• Leverage the power of Pivot Tables & Ranges.

Spreadsheet Cloud Storage Features

• Upload, download, copy, move and delete files, including versions handling (if you are using Cloud storage that supports this feature - true by default).
• Create, copy, move and delete folders.
• Copy and move files and folders accross separate storages in scope of a single operation.
• Check if certain file, folder or storage exists.

Read & Write Spreadsheet Formats

Microsoft Excel®: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM
OpenOffice®: ODS
SpreadsheetML: XML
Text: CSV, TSV, TXT (TabDelimited)
Web: HTML, MHTML
Fixed Layout: PDF

Save Spreadsheet As

DIF, HTML, MHTML, PNG, JPG, TIFF, XPS, SVG, MD (Markdown), ODS, XLSX, XLS, XLSB, PDF, XML, TXT, CSV

Read Other Formats

SXC, FODS

Requirements

Building the API client library requires:

1. Java 1.7+
2. Maven

Prerequisites

To use Aspose.Cells Cloud SDK for Java you need to register an account with Aspose Cloud and lookup/create Client ID and Client Secret at Cloud Dashboard. There is free quota available. For more details, see Aspose Cloud Pricing.

Installation

Install from Maven

Add Aspose Cloud repository to your application pom.xml

<repositories>
    <repository>
        <id>AsposeJavaAPI</id>
        <name>Aspose Java API</name>
        <url>https://releases.aspose.cloud/java/repo/</url>
    </repository>
</repositories>

Install from source

To install the API client library to your local Maven repository, simply execute:

mvn clean install

To deploy it to a remote Maven repository instead, configure the settings of the repository and execute:

mvn clean deploy

Refer to the OSSRH Guide for more information.

Maven users

Add this dependency to your project’s POM:

<dependencies>
    <dependency>
        <groupId>com.aspose</groupId>
        <artifactId>aspose-cells-cloud</artifactId>
        <version>22.5</version>
    </dependency>
</dependencies>

Others

At first generate the JAR by executing:

mvn clean package

Then manually install the following JARs:

• target/aspose-cells-cloud-22.5.jar
• target/lib/*.jar

Using Java to Add a Worksheet to an Excel® File

CellsApi cellsApi = new CellsApi(CellsApiUtil.GetClientId(),CellsApiUtil.GetClientSecret())
String name = BOOK1;
String sheetName = SHEET1;
Integer position = 1;
String sheettype ="VB";
String folder = TEMPFOLDER;
cellsApi.uploadFile(folder +"\\" + filename, new File(sourceFolder + filename), null);
WorksheetsResponse response = cellsApi.cellsWorksheetsPutAddNewWorksheet(name, sheetName, position, sheettype, folder,null);

Convert Excel® File in the Cloud

String name = BOOK1;
SaveOptions saveOptions = null;
String newfilename = "newbook.xlsx";
Boolean isAutoFitRows = true;
Boolean isAutoFitColumns = false;
String folder = TEMPFOLDER;
// Upload source file to aspose cloud storage
cellsApi.uploadFile(folder +"\\" + filename, new File(sourceFolder + filename), null);
// Invoke Aspose.Cells Cloud SDK API to convert Excel® workbook to different format
SaveResponse response = cellsApi.cellsSaveAsPostDocumentSaveAs(name, saveOptions, newfilename, isAutoFitRows, isAutoFitColumns, folder,null);

Licensing

All Aspose.Cells Cloud SDKs, helper scripts and templates are licensed under MIT License.

Authorization & Authentication

Authentication schemes defined for the API is as follows:

JWT

• Type: OAuth
• Flow: application
• Authorization URL: https://api.aspose.cloud/connect/token

Recommendation

It’s recommended to create an instance of ApiClient per thread in a multithreaded environment to avoid any potential issues.

Product Page | Documentation | Live Demo | Swagger UI | Code Samples | Blog | Free Support | Free Trial