Features
Contents
[
Hide
]
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. |