Features

Aspose.Cells for Node.js via Java Features Overview

This section provides a comparison of the availability of features between Aspose.Cells for Java and Aspose.Cells for Node.js via Java.

File Formats and Conversions

Many customers worldwide rely on the thorough document import and export features provided by Aspose.Cells.

Feature	Description	Aspose.Cells for Java	Aspose.Cells for Node.js via Java
High-Quality Conversions	Quickly and reliably convert between several popular document formats.	👁 tick	👁 tick
Microsoft Excel Workbook (XLS)	The fastest and most complete XLS format implementation you can find.	👁 tick	👁 tick
SpreadsheetML (XLSX, XML)	Aspose.Cells supports OOXML, Flat OPC and also Excel 2003 XML. Moreover, the component supports all major Excel 2007 and later versions file formats, e.g., XLSX, XLTX, XLSM, XLTM, etc.	👁 tick	👁 tick
Comma Separated Value (CSV)	Comprehensive support of the CSV format to interact with a variety of applications.	👁 tick	👁 tick
HTML	Save as HTML is available.	👁 tick	👁 tick
OpenDocument (ODS)	Aspose.Cells can load and save documents in the OpenDocument Spreadsheet (.ods) format.	👁 tick	👁 tick
Adobe Portable Document Format (PDF)	Convert any Spreadsheet to PDF with high fidelity.	👁 tick	👁 tick
Tab Delimited	Load and save documents in the tab delimited file format.	👁 tick	👁 tick
Plain Text (TXT)	Easily extract text by saving in plain text format.	👁 tick	👁 tick

Rendering and Printing

Aspose.Cells now provides high fidelity rendering of spreadsheet pages.

Feature	Aspose.Cells for Java	Aspose.Cells for Node.js via Java
Layout documents into pages with high fidelity to Microsoft Excel® (exactly as Microsoft Excel® would do).	👁 tick	👁 tick
Render worksheet pages to raster images (PNG, JPEG, etc.).	👁 tick	👁 tick
Render worksheet pages to raster images (Multipage TIFF, GIF).	👁 tick	👁 tick
Render spreadsheet pages to vector images (EMF).	👁 tick	👁 tick
Specify image resolution, quality, compression and other options.	👁 tick	👁 tick
Print spreadsheet pages using the Java printing infrastructure.	👁 tick	👁 circle
Update page numbers and other fields before rendering or printing.	👁 tick	👁 tick

Spreadsheet Content Features

Aspose.Cells provides a rich object model that consists of over 100 public classes/interfaces, which allow you to programmatically generate, combine, modify, parse, or otherwise examine loaded spreadsheets. Some key features are listed in the table below.

Feature	Aspose.Cells for Java	Aspose.Cells for Node.js via Java
Import/export data from an Array, ArrayList, ResultSet etc.	👁 tick	👁 circle
Add a copy of existing worksheet (all contents including images, charts, other objects etc.)	👁 tick	👁 tick
Copy or move worksheets within or between workbooks	👁 tick	👁 tick
Insert images	👁 tick	👁 tick
Create charts	👁 tick	👁 tick
Set gradient background for charts using API	👁 tick	👁 tick
Add comments to cells	👁 tick	👁 tick
Microsoft Excel 2007 and later versions themes and colors	👁 tick	👁 tick
Create auto-filters	👁 tick	👁 tick
Implement data validations	👁 tick	👁 tick
Implement data sorting	👁 tick	👁 tick
Find and replace text	👁 tick	👁 tick
Merge/Split cells	👁 tick	👁 tick
Group/ungroup rows and columns	👁 tick	👁 tick
Create custom page breaks	👁 tick	👁 tick
Insert/delete or hide rows, columns, and sheets	👁 tick	👁 tick
Calculate complex Excel formulae	👁 tick	👁 tick
Support advanced conditional formatting in Microsoft Excel 2007 and later versions	👁 tick	👁 tick
Freeze/Unfreeze panes	👁 tick	👁 tick
Insert hyperlinks to link data	👁 tick	👁 tick
Implement Smart Markers	👁 tick	👁 tick
Specify document property settings	👁 tick	👁 tick
Protect/unprotect worksheets	👁 tick	👁 tick
Specify advanced protection options introduced in Excel XP and later versions	👁 tick	👁 tick
Create list objects/Microsoft Excel tables	👁 tick	👁 tick
Create subtotals	👁 tick	👁 tick
Insert form controls and other drawing shapes/objects	👁 tick	👁 tick
Create pivot tables and pivot charts	👁 tick	👁 tick
Preserve or remove add‑in, VBA, macros	👁 tick	👁 tick
Manipulate named ranges	👁 tick	👁 tick
Create custom charts	👁 tick	👁 tick
Add, preserve or extract OLE objects from the spreadsheets.	👁 tick	👁 tick
Implement sparklines	👁 tick	👁 tick
Encrypt files	👁 tick	👁 tick

Spreadsheet Formatting Features

Aspose.Cells provides detailed programmatic access to formatting properties of all spreadsheet elements.

Feature	Aspose.Cells for Java	Aspose.Cells for Node.js via Java
Apply character formatting to cells, including fonts, colors, effects, borders, and shading.	👁 tick	👁 tick
Apply all number format settings (supported in Microsoft Excel) to cells.	👁 tick	👁 tick
Set all types of text alignment settings.	👁 tick	👁 tick
Apply different font settings to cells.	👁 tick	👁 tick
Apply different colors to cells, fonts, gridlines, graphic objects, etc.	👁 tick	👁 tick
Apply different rich text formatting in a single cell.	👁 tick	👁 tick
Apply different border settings to cells.	👁 tick	👁 tick
Apply different background patterns to cells.	👁 tick	👁 tick
Apply format settings to a worksheet, row, column, or a range of cells, etc.	👁 tick	👁 tick

PageSetup Features

You can use Aspose.Cells to implement page setup options for worksheets.

Feature	Aspose.Cells for Java	Aspose.Cells for Node.js via Java
Adjust page orientation, scaling, and paper size.	👁 tick	👁 tick
Specify margins and page centering.	👁 tick	👁 tick
Create or edit header and/or footer.	👁 tick	👁 tick
Set print area, print titles, or turn on gridlines, etc.	👁 tick	👁 tick