asposecellscloud

Node.js Cloud SDK wraps Aspose.Cells REST API so you could seamlessly integrate Microsoft Excel® document generation, manipulation, conversion & inspection features into your own Node.js applications.

Node.js package for Aspose.Cells Cloud

This repository contains Aspose.Cells Cloud SDK for Node.js source code. This SDK enables you to engage with various aspects of worksheets such as cell data, cell formatting, formulas, charts, pivot tables, data validation, comments, drawing objects, images, hyperlinks, as well as text and number formatting. Additionally, it offers functionalities for manipulating rows, columns, and protection settings. With Aspose.Cells Cloud SDK for Node.js, you can extend your applications to append and split worksheets, merge cells, and convert worksheets to a range of supported file formats, seamlessly integrating with the powerful Aspose.Cells Cloud REST APIs. We encourage you to dive into the Developer's Guide & API Reference for a comprehensive insight into everything Aspose.Cells Cloud API can offer. Enhance your Node.js applications today by leveraging the full suite of features aimed at making worksheet management as efficient as possible.

Quick Start Guide

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

• Create an account at Aspose for Cloud and obtain your application information.
• execute npm install asposecellscloud --save from the command line to install Aspose.Cells Cloud for Node.js via NPM.
• You need to set your CellsCloudClientId and CellsCloudClientSecret in the environment variables.

  import { CellsApi, PutConvertWorkbookRequest, UploadFileRequest } from "asposecellscloud";
var fs = require('fs');
var path = require('path');
var process = require('process');
const _ = require('asposecellscloud');

const cellsApi = new CellsApi(process.env.CellsCloudClientId, process.env.CellsCloudClientSecret);

var localPath = "TestData/CellsCloud/"
var localName = "Book1.xlsx"

describe('quicktest', function(){
  it("should call quicktest successfully" , function(){

      var format = "csv"

      var mapFiles: { [key: string]: any } = {};

      mapFiles[localName]= fs.createReadStream(localPath  +localName) ;

      var request = new PutConvertWorkbookRequest();
      request.file =  mapFiles;
      request.format =  format;
      var response  =  cellsApi.putConvertWorkbook(request);
  });
});

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.	√	√
TXT	Delimited plain text file.	√	√
HTML	HTML format.	√	√
MHTML	MHTML file.	√	√
ODS	ODS (OpenDocument Spreadsheet).	√	√
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		√

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 v25.7.0

Full list of issues covering all changes in this release:

Summary	Category
Optimize operate scope options for extProcessingController.	Improvement
Add protect/unprotect spreadsheet APIs.	New Feature
Add convert worksheet/table/range to other formats.	New Feature

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.

Release history version