<dependency>
    <groupId>com.aspose</groupId>
    <artifactId>aspose-cells-cloud</artifactId>
    <version>21.11</version>
</dependency>
copied!  
compile(group: 'com.aspose', name: 'aspose-cells-cloud', version: '21.11')
copied!  
<dependency org="com.aspose" name="aspose-cells-cloud" rev="21.11">
    <artifact name="aspose-cells-cloud" ext="jar"/>
</dependency>
copied!  
libraryDependencies += "com.aspose" % "aspose-cells-cloud" % "21.11"
copied!  

Java SDK for Spreadsheet Processing in the Cloud

banner

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&reg; 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

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

VersionRelease Date
22.11November 16, 2022
22.9September 22, 2022
22.8August 24, 2022
22.7July 29, 2022
22.6June 28, 2022
22.5May 30, 2022
22.4April 20, 2022
22.3March 14, 2022
22.2February 24, 2022
22.1January 24, 2022
21.12December 28, 2021
21.11November 30, 2021
21.10November 8, 2021
21.9October 13, 2021
21.8September 18, 2021
21.7August 3, 2021
21.6July 16, 2021
21.5May 27, 2021
21.1January 25, 2021
20.11December 4, 2020
20.10October 23, 2020
20.9September 23, 2020
20.8August 19, 2020
20.7July 21, 2020
20.6July 2, 2020
1.0.0May 12, 2020
1.0.1May 12, 2020
1.0.2May 12, 2020
20.4April 22, 2020
20.2February 20, 2020
20.1January 17, 2020
19.10October 30, 2019
19.9September 25, 2019
19.6June 18, 2019
19.2.1February 22, 2019
19.2February 19, 2019
18.9.1September 6, 2018
18.9September 5, 2018
18.8August 15, 2018
18.4August 2, 2018
18.2February 27, 2018
 
 English