Skip to content

Files

Latest commit

397e7b1 · May 21, 2025

History

History
157 lines (130 loc) · 13 KB

README.md

File metadata and controls

157 lines (130 loc) · 13 KB

Product Page Documentation API Ref Examples Blog Support License

Java package for Aspose.Cells Cloud

Enhance your Java applications with the Aspose.Cells Cloud , enabling seamless integration with Excel, ODS, CSV, Json and other spreadsheet document formats. With its powerful APIs, developers can effortlessly read, convert, create, edit, and manipulate the contents of Excel documents without the need for any office software installed on the machine

Quick Start Guide

To get started with Aspose.Cells Cloud for Java, follow these steps:

  1. Create an account at Aspose for Cloud and obtain your application information.
  2. Add the following dependency to your project's POM:
  3. You need to set your CellsCloudClientId and CellsCloudClientSecret in the environment variables.
<repositories>
    <repository>
        <id>AsposeJavaAPI</id>
        <name>Aspose Java API</name>
        <url>https://repository.aspose.cloud/repo/</url>
    </repository>
</repositories>

<dependencies>
    <dependency>
        <groupId>com.aspose</groupId>
        <artifactId>aspose-cells-cloud</artifactId>
        <version>25.3.0</version>
    </dependency>
</dependencies>
package com.aspose.cloud.cells.api;
import com.aspose.cloud.cells.client.*;
import com.aspose.cloud.cells.model.*;
import com.aspose.cloud.cells.request.*;
import org.junit.Test;
import java.util.ArrayList;
import java.util.List;
import java.io.File;
import java.util.HashMap;
import junit.framework.Assert;

public class ConversionTest {
    private String remoteFolder = "TestData/In";
    CellsApi cellsApi = new CellsApi(System.getenv("CellsCloudClientId"),System.getenv("CellsCloudClientSecret"));

    public void putConvertWorkbook() throws Exception {
        private String remoteFolder = "TestData/In";
        String localName = "Book1.xlsx";
        String remoteName = "Book1.xlsx";
        String format = "csv";
        CellsApiUtil.Upload(api,  remoteFolder + "/" + remoteName , localName , "");
        PutConvertWorkbookRequest request = new PutConvertWorkbookRequest();
        request.setFormat(format);
        HashMap<String,File> fileMap = new HashMap<String,File>();
        fileMap.put(localName ,CellsApiUtil.GetFileHolder(localName) );
        request.setFile(fileMap);
        File response =  this.api.putConvertWorkbook(request);
    }
}

Manipulate Excel and other spreadsheet files in the Cloud

  • File Manipulation: Users can upload, download, delete, and manage Excel files stored in the cloud.
  • Formatting: Supports formatting of cells, fonts, colors, and alignment modes in Excel files to cater to users' specific requirements.
  • Data Processing: Powerful functions for data processing including reading, writing, modifying cell data, performing formula calculations, and formatting data.
  • Formula Calculation: Built-in formula engine handles complex formula calculations in Excel and returns accurate results.
  • Chart Manipulation: Users can create, edit, and delete charts from Excel files for data analysis and visualization needs.
  • Table Processing: Offers robust processing capabilities for various form operations such as creation, editing, formatting, and conversion, meeting diverse form processing needs.
  • Data Verification: Includes data verification function to set cell data type, range, uniqueness, ensuring data accuracy and integrity.
  • Batch Processing: Supports batch processing of multiple Excel documents, such as batch format conversion, data extraction, and style application..
  • Import/Export: Facilitates importing data from various sources into spreadsheets and exporting spreadsheet data to other formats.
  • Security Management: Offers a range of security features like data encryption, access control, and permission management to safeguard the security and integrity of spreadsheet data.

Feature & Enhancements in Version 25.5.0

Full list of issues covering all changes in this release:

Summary Category
Add the new API for getting public key about encrypt password. New Feature
Optimize convert workbook feature: Add auto fit row parameter. Improvement
Optimize auto fit rows for worksheet. Improvement
Optimize auto fit rows for worksheet: Add firstColumn and lastColumn. Improvement

Support file format

Format Description Load Save
XLS Excel 95/5.0 - 2003 Workbook.
XLSX Office Open XML SpreadsheetML Workbook or template file, with or without macros.
XLSB Excel Binary Workbook.
XLSM Excel Macro-Enabled Workbook.
XLT Excel 97 - Excel 2003 Template.
XLTX Excel Template.
XLTM Excel Macro-Enabled Template.
XLAM An Excel Macro-Enabled Add-In file that's used to add new functions to Excel.  
CSV CSV (Comma Separated Value) file.
TSV TSV (Tab-separated values) file.
TabDelimited Tab-delimited text file, same with TSV file.
TXT Delimited plain text file.
HTML HTML format.
MHTML MHTML file.
ODS ODS (OpenDocument Spreadsheet).
SpreadsheetML Excel 2003 XML file.
Numbers The document is created by Apple's "Numbers" application which forms part of Apple's iWork office suite, a set of applications which run on the Mac OS X and iOS operating systems.
JSON JavaScript Object Notation
DIF Data Interchange Format.  
PDF Adobe Portable Document Format.  
XPS XML Paper Specification Format.  
SVG Scalable Vector Graphics Format.  
TIFF Tagged Image File Format  
PNG Portable Network Graphics Format  
BMP Bitmap Image Format  
EMF Enhanced metafile Format  
JPEG JPEG is a type of image format that is saved using the method of lossy compression.  
GIF Graphical Interchange Format  
MARKDOWN Represents a markdown document.  
SXC An XML based format used by OpenOffice and StarOffice
FODS This is an Open Document format stored as flat XML.
DOCX A well-known format for Microsoft Word documents that is a combination of XML and binary files.
PPTX The PPTX format is based on the Microsoft PowerPoint open XML presentation file format.
OTS OTS (OpenDocument Spreadsheet).
XML XML file.
HTM HTM file.
TIF Tagged Image File Format  
WMF WMF Image Format  
PCL Printer Command Language Format  
AZW3 AZ3/KF8 File Format  
EPUB EPUB File Format  
DBF DBF File Format  
EPUB database file  
XHTML XHTML File Format  

Available SDKs

The Aspose.Cells Cloud SDK is available in multiple popular programming languages, enabling developers to integrate spreadsheet processing capabilities across various development environments.

Go Go

Java Java

C# .NET

Node.js Node.js

Perl Perl

PHP PHP

Python Python

Ruby Ruby