JavaScript APIs to manipulate Excel spreadsheets

Dynamically Create, Manipulate or Convert Excel Spreadsheets without requiring Microsoft Excel.

  Download Free Trial
Aspose.Cells for JavaScript via Java

Aspose.Cells for JavaScript via Java

 
 

Aspose.Cells for JavaScript via Java is an Excel Spreadsheet Processing API that allows the developers to employ the ability to read, write and manipulate Excel spreadsheets via Node.js.

Aspose.Cells for JavaScript via Java is a scalable and feature rich API that offers spreadsheet format conversion, styling of worksheets to the most granular level, chart management & rendering, and our world renowned Formula Calculate Engine.

 

Advanced JavaScript Excel Spreadsheet API Features

Aspose.Cells for JavaScript via Java includes the following features:

 

Support for CSV, Tab-delimited & HTML formats

 

Load & save OpenDocument Spreadsheet (.ods) format

 

Create, manipulate & render charts

 

Import formulas from a designer spreadsheet

 

Configure page setup

 

Create & manipulate comments

 

Set auto-filters & page breaks

 

Set & calculate complex formulas

 

Create & manipulate conditional formatting rules

 

Set security/protection options

 

Create & manipulate named ranges

 

Populate worksheets through Smart Markers

 

Create, manipulate & refresh Pivot Tables

 

Export worksheets in SVG format

 

Create & render sparklines

Rendering Excel Spreadsheets

Aspose.Cells for JavaScript via Java has its own rendering engine specially designed for rendering with highest of fidelity to the Microsoft Excel. While using Aspose.Cells for JavaScript via Java, you can convert whole spreadsheets, individual worksheets & charts to a number of image & fixed-layout formats.

Flexible Worksheet Display Options

Aspose.Cells for JavaScript via Java gives you the complete control over the worksheet's page setup thus allowing you to manipulate Excel worksheet's display options such as page breaks, page orientation, scaling, paper size, headers/footers & zoom level. You may also control the data visibility using freeze panes & print area to suit your application requirements.

Security Options

Aspose.Cells for JavaScript via Java offers a wide range of security features including spreadsheet encryption/decryption, content, object & scenario protection as well as the ability to hide and un-hide rows, columns & worksheets.

Manipulate Rows & Columns

Aspose.Cells for JavaScript via Java allows you to manipulate rows and columns in many different ways. You can easily adjust row height & column width, auto size the cells according to the contents, insert & delete, hide & un-hide as well as group & un-group rows & columns.

Comprehensive Support for Worksheet Formatting

Aspose.Cells for JavaScript via Java provides advanced formatting features that allows you to control the presentation of your data in the spreadsheets. You can apply formatting to a worksheet, row, column or a cell. You can also add Rich Text to a single cell, apply borders, set background patterns and apply font styling. The API also allows to add, manipulate & calculate conditional formatting rules on the fly.

Chart Creation, Manipulation & Rendering

Aspose.Cells for JavaScript via Java comes with complete support for charting. You can easily add standard or customized charts using the product API, and dynamically set the data in order to refresh the charts. The API also allows you to convert charts to a number of image formats & PDF.

 

Support and Learning Resources