Features
Aspose.Cells for Node.js via C++ Features Overview
This section provides a comparison of the availability of features between Aspose.Cells for C++ and Aspose.Cells for Node.js via C++.
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 C++ | Aspose.Cells for Node.js via C++ |
---|---|---|---|
High-Quality Conversions | Quickly and reliably, convert between several popular document formats. |
|
|
Microsoft Excel Workbook (XLS) | The fastest and most complete XLS format implementation you can find. |
|
|
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. |
|
|
Comma Separated Value (CSV) | Comprehensive support of the CSV format to interact with a variety of applications. |
|
|
HTML | Save as HTML is available. |
|
|
OpenDocument (ODS) | Aspose.Cells can load and save documents in the OpenDocument Spreadsheet (.ods) format. |
|
|
Adobe Portable Document Format (PDF) | Convert any Spreadsheet to PDF with high fidelity. |
|
|
Tab Delimited | Load and save documents in the tab delimited file format. |
|
|
Plain Text (TXT) | Easily extract text by saving in plain text format. |
|
|
Rendering and Printing
Aspose.Cells now provides high fidelity rendering of spreadsheet pages.
Feature | Aspose.Cells for C++ | Aspose.Cells for Node.js via C++ |
---|---|---|
Layout document into pages with high fidelity to Microsoft Excel® (exactly like Microsoft Excel® would do that). |
|
|
Render worksheet pages to raster images (PNG, JPEG, etc.). |
|
|
Render worksheet pages to raster images (Multipage TIFF, GIF). |
|
|
Render spreadsheet pages to vector images (EMF). |
|
|
Specify image resolution, quality, compression and other options. |
|
|
Print spreadsheet pages using the C++ printing infrastructure. |
|
|
Update page numbers and other fields before rendering or printing. |
|
|
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 given in the below table.
Feature | Aspose.Cells for C++ | Aspose.Cells for Node.js via C++ |
---|---|---|
Import/export data from an Array, ArrayList, ResultSet etc. |
|
|
Add a copy of existing worksheet (all contents including images, charts, other objects etc.) |
|
|
Copy or move worksheets within or between workbooks |
|
|
Insert images |
|
|
Create charts |
|
|
Set gradient background for charts using API |
|
|
Add comments to cells |
|
|
Microsoft Excel 2007 and later versions themes and colors |
|
|
Create auto-filters |
|
|
Implement data validations |
|
|
Implement data sorting |
|
|
Find and replace text |
|
|
Merge/split Cells |
|
|
Group/ungroup rows and columns |
|
|
Create custom page breaks |
|
|
Insert/delete or hide rows, columns, and sheets |
|
|
Calculate complex Excel formulae |
|
|
Support advanced conditional formatting supported in Microsoft Excel 2007 and later versions |
|
|
Freeze/unfreeze Panes |
|
|
Insert hyperlinks to link data |
|
|
Implement Smart Markers |
|
|
Specify document properties settings |
|
|
Protect/unprotect worksheets |
|
|
Specify advanced protection options introduced in Excel XP and later versions |
|
|
Create list object/Microsoft Excel tables |
|
|
Create subtotals |
|
|
Insert form controls and other drawing shapes/objects |
|
|
Create pivot tables and pivot charts |
|
|
Preserve or remove addin, VBA, macros |
|
|
Manipulate named ranges |
|
|
Create custom charts |
|
|
Add, preserve or extract OLE objects from the spreadsheets. |
|
|
Implement sparklines |
|
|
Encrypt files |
|
|
Spreadsheet Formatting Features
Aspose.Cells provides detailed programmatic access to formatting properties of all spreadsheet elements.
Feature | Aspose.Cells for C++ | Aspose.Cells for Node.js via C++ |
---|---|---|
Apply all characters formatting in the cells including fonts, colors, effects, borders, and shading. |
|
|
Apply all the number format settings (supported in Microsoft Excel) for the cells. |
|
|
Set all types of text alignment settings. |
|
|
Apply different kinds of Font Settings for the cells. |
|
|
Apply different colors to cells, fonts, gridlines, graphic objects etc. |
|
|
Apply different rich text formatting in a single cell. |
|
|
Apply different border settings on cells. |
|
|
Apply different background patterns on cells. |
|
|
Apply Format settings on a worksheet, row, column or a range of cells, etc. |
|
|
PageSetup Features
You can use Aspose.Cells to implement page setup options for worksheets.
Feature | Aspose.Cells for C++ | Aspose.Cells for Node.js via C++ |
---|---|---|
Adjust your page orientation, scaling, paper size. |
|
|
Specify your margins and page centering. |
|
|
Create or edit your header and/or footer. |
|
|
Set print area, print titles, or turn on gridlines etc. |
|
|