Java SDK for Spreadsheet Processing in the Cloud
This Cloud SDK enhances your Java-based cloud apps to process & manipulate Microsoft Excel spreadsheets in the cloud.
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.
Feature & Enhancements in Version 21.1
- Support to convert worksheet on task API.
- Support to add and delete cell or range in worksheet.
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 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
Get Started with Aspose.Cells Cloud SDK for Java
You do not need to install anything to get started with Aspose.Cells Cloud SDK for Java. Just create an account at Aspose for Cloud and get your application information.
Next, add the following dependency to your project's POM:
<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>20.10.0</version>
</dependency>
</dependencies>
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);
Aspose.Cells Cloud SDKs in Popular Languages
.NET | PHP | Python | Ruby | Node.js | Android | Swift | Perl | GO |
---|---|---|---|---|---|---|---|---|
GitHub | GitHub | GitHub | GitHub | GitHub | GitHub | GitHub | GitHub | GitHub |
NuGet | Composer | PIP | GEM | NPM | Maven | POD | CPAN | GO |
Product Page | Documentation | Live Demo | API Reference | Code Samples | Blog | Free Support | Free Trial