aspose.cells
Advanced tools
Comparing version 24.6.0 to 24.7.0
{ | ||
"name": "aspose.cells", | ||
"version": "24.6.0", | ||
"description": "A powerful library for manipulating and converting Excel (XLS, XLSX, XLSB), ODS, CSV and HTML files.", | ||
"main": "index.js", | ||
"version": "24.7.0", | ||
"description": "Aspose.Cells for Node.js via C++ is a high-performance and powerful library for manipulating and converting Excel (XLS, XLSX, XLSB), ODS, CSV, and HTML files, offering a comprehensive set of features for creating, editing, converting, and rendering spreadsheets within Node.js applications.", | ||
"main": "./lib/aspose.cells.js", | ||
"types": "./lib/types.d.ts", | ||
"binary": { | ||
"module_name": "aspose.cells.nodejs", | ||
"module_path": "./lib", | ||
"remote_path": "./aspose-cells/aspose.cells-for-nodejs/releases/download/v{version}", | ||
"package_name": "{module_name}-v{version}-{platform}{toolset}-{arch}.tar.gz", | ||
"host": "https://github.com/" | ||
}, | ||
"scripts": { | ||
"test": "echo \"Error: no test specified\" && exit 1" | ||
"install": "node download-aspose.cells.js" | ||
}, | ||
"engines" : { "node" : ">=12" }, | ||
"keywords": [ | ||
@@ -35,9 +44,7 @@ "Excel", | ||
"author": "Aspose", | ||
"license": "End User License Agreement.html", | ||
"license": "Commercial", | ||
"homepage": "https://www.aspose.com", | ||
"dependencies": { | ||
"java": ">=0.14.0" | ||
}, | ||
"directories": { | ||
"lib": "lib" | ||
"@mapbox/node-pre-gyp": "^1.0.11" | ||
} | ||
} | ||
} |
@@ -1,15 +0,11 @@ | ||
Aspose.Cells for Node.js via Java is a scalable and feature-rich API to create, process, manipulate & convert Excel & OpenOffice spreadsheets using Node.js. API offers Excel file generation, conversion, worksheets styling, Pivot Table & chart management & rendering, reliable formula calculation engine and much more - all without any dependency on Office Automation or Microsoft Excel®. | ||
Aspose.Cells for Node.js via C++ is a powerful and robust library designed for high-performance spreadsheet manipulation and management within Node.js applications. It offers a comprehensive set of features that enable developers to create, edit, convert, and render Excel files programmatically. Supporting all major Excel formats, including XLS, XLSX, XLSM, and more, it ensures compatibility and flexibility. This makes Aspose.Cells for Node.js via C++ a versatile tool for a wide range of data processing and management tasks, providing developers with a complete and efficient solution for integrating comprehensive Excel functionality into their Node.js applications. | ||
## Node.js Spreadsheet API Features | ||
- Generate Excel files via API or using templates. | ||
- Create Pivot Tables, charts, sparklines & conditional formatting rules on-the-fly. | ||
- Refresh existing charts & convert charts to images or PDF. | ||
- Create & manipulate comments & hyperlinks. | ||
- Set complex formulas & calculate results via API. | ||
- Set protection on workbooks, worksheets, cells, columns or rows. | ||
- Create & manipulate named ranges. | ||
- Populate worksheets through Smart Markers. | ||
- Manipulate & refresh Pivot Tables via API. | ||
- Convert worksheets to PDF, XPS & SVG formats. | ||
- Inter-convert files to popular Excel formats. | ||
## Key features | ||
- **File Creation and Editing:** Create new spreadsheets from scratch or edit existing ones with ease. This includes adding or modifying data, formatting cells, managing worksheets, and more. | ||
- **Data Processing:** Perform complex data manipulations such as sorting, filtering, and validation. The library also supports advanced formulas and functions to facilitate data analysis and calculations. | ||
- **File Conversion**: Convert Excel files to various formats such as PDF, HTML, ODS, and image formats like PNG and JPEG. This feature is useful for sharing and distributing spreadsheet data in different formats. | ||
- **Chart and Graphics**: Create and customize a wide range of charts and graphics to visually represent data. The library supports bar charts, line charts, pie charts, and many more, along with customization options for design and layout. | ||
- **Rendering and Printing**: Render Excel sheets to high-fidelity images and PDFs, ensuring that the visual representation is accurate. The library also provides options for printing spreadsheets with precise control over page layout and formatting. | ||
- **Advanced Protection and Security**: Protect spreadsheets with passwords, encrypt files, and manage access permissions to ensure data security and integrity. | ||
- **Performance and Scalability**: Designed to handle large datasets and complex spreadsheets efficiently, Aspose.Cells for Node.js via C++ ensures high performance and scalability for enterprise-level applications. | ||
@@ -27,3 +23,8 @@ ## Read & Write Excel Files | ||
## Getting Started with Aspose.Cells for Nodejs via Java | ||
## Support multiple operating systems and CPU architectures, including: | ||
- **Windows x64** | ||
- **Linux x64** | ||
- **macOS x64 & arm64** | ||
## Getting Started with Aspose.Cells for Node.js via C++ | ||
### Installation | ||
@@ -35,44 +36,41 @@ | ||
### Create Excel XLSX File from Scratch using Node.js | ||
### Create Excel XLSX File from Scratch | ||
``` js | ||
var aspose = aspose || {}; | ||
aspose.cells = require("aspose.cells"); | ||
const AsposeCells = require("aspose.cells"); | ||
var workbook = new aspose.cells.Workbook(aspose.cells.FileFormatType.XLSX); | ||
workbook.getWorksheets().get(0).getCells().get("A1").putValue("testing..."); | ||
workbook.save("output.xlsx"); | ||
var workbook = new AsposeCells.Workbook(AsposeCells.FileFormatType.Xlsx); | ||
workbook.getWorksheets().get(0).getCells().get("A1").putValue("Hello World"); | ||
workbook.save("hello-world.xlsx"); | ||
``` | ||
### Convert Excel XLSX File to PDF using Node.js | ||
### Convert Excel XLSX File to PDF | ||
``` js | ||
var aspose = aspose || {}; | ||
aspose.cells = require("aspose.cells"); | ||
const { Workbook } = require("aspose.cells"); | ||
var workbook = new aspose.cells.Workbook("example.xlsx"); | ||
var saveOptions = aspose.cells.PdfSaveOptions(); | ||
saveOptions.setOnePagePerSheet(true); | ||
workbook.save("example.pdf", saveOptions); | ||
var workbook = new Workbook("example.xlsx"); | ||
workbook.save("pdf-example.pdf"); | ||
``` | ||
### Format Excel Cells via Node.js | ||
### Format Excel Cells | ||
```js | ||
var aspose = aspose || {}; | ||
aspose.cells = require("aspose.cells"); | ||
const { Workbook, Color } = require("aspose.cells"); | ||
var excel = new aspose.cells.Workbook(); | ||
var style = excel.createStyle(); | ||
var workbook = new Workbook(); | ||
var style = workbook.createStyle(); | ||
style.getFont().setName("Times New Roman"); | ||
style.getFont().setColor(aspose.cells.Color.getBlue()); | ||
for (var i = 0; i < 100; i++) | ||
{ | ||
excel.getWorksheets().get(0).getCells().get(0, i).setStyle(style); | ||
var blue = new Color(0, 0, 0xff); | ||
style.getFont().setColor(blue); | ||
for (var i = 0; i < 10; i++) { | ||
var cell = workbook.getWorksheets().get(0).getCells().get(0, i); | ||
cell.putValue(i); | ||
cell.setStyle(style); | ||
} | ||
workbook.save("style-example.xlsx"); | ||
``` | ||
### Add Picture to Excel Worksheet with Node.js | ||
### Add Picture to Excel Worksheet | ||
```js | ||
var aspose = aspose || {}; | ||
aspose.cells = require("aspose.cells"); | ||
const { Workbook, SaveFormat } = require("aspose.cells"); | ||
var workbook = new aspose.cells.Workbook(); | ||
var workbook = new Workbook(); | ||
var sheetIndex = workbook.getWorksheets().add(); | ||
@@ -84,5 +82,8 @@ var worksheet = workbook.getWorksheets().get(sheetIndex); | ||
workbook.save("output.xls", aspose.cells.SaveFormat.EXCEL_97_TO_2003); | ||
workbook.save("picture-example.xls", SaveFormat.Excel97To2003); | ||
``` | ||
[Product Page](https://products.aspose.com/cells/nodejs-java) | [Product Documentation](https://docs.aspose.com/display/cellsnodejsjava/Aspose.Cells+for+Node.js+via+Java+Home) | [Blog](https://blog.aspose.com/category/cells/) |[API Reference](https://apireference.aspose.com/cells/nodejs) | [Source Code Samples](https://github.com/aspose-cells/Aspose.Cells-for-Java) | [Free Support](https://forum.aspose.com/c/cells) | [Temporary License](https://purchase.aspose.com/temporary-license) | ||
# Note | ||
Starting from v24.7.0, Aspose.Cells for Node.js via Java has been migrated to [aspose.cells.java](https://www.npmjs.com/package/aspose.cells.java). | ||
[Product Page](https://products.aspose.com/cells/nodejs-cpp) | [Product Documentation](https://docs.aspose.com/cells/nodejs-cpp/) | [Blog](https://blog.aspose.com/categories/aspose.cells-product-family/) |[API Reference](https://reference.aspose.com/cells/nodejs-cpp) | [Free Support](https://forum.aspose.com/c/cells) | [Temporary License](https://purchase.aspose.com/temporary-license) |
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
Install scripts
Supply chain riskInstall scripts are run when the package is installed. The majority of malware in npm is hidden in install scripts.
Found 1 instance in 1 package
Deprecated
MaintenanceThe maintainer of the package marked it as deprecated. This could indicate that a single version should not be used, or that the package is no longer maintained and any new vulnerabilities will not be fixed.
Found 1 instance in 1 package
Major refactor
Supply chain riskPackage has recently undergone a major refactor. It may be unstable or indicate significant internal changes. Use caution when updating to versions that include significant changes.
Found 1 instance in 1 package
Shell access
Supply chain riskThis module accesses the system shell. Accessing the system shell increases the risk of executing arbitrary code.
Found 1 instance in 1 package
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
No tests
QualityPackage does not have any tests. This is a strong signal of a poorly maintained or low quality package.
Found 1 instance in 1 package
No website
QualityPackage does not have a website.
Found 1 instance in 1 package
0
87
159841
5
17
1
1
2
+ Added@mapbox/node-pre-gyp@^1.0.11
+ Added@mapbox/node-pre-gyp@1.0.11(transitive)
+ Addedabbrev@1.1.1(transitive)
+ Addedagent-base@6.0.2(transitive)
+ Addedansi-regex@5.0.1(transitive)
+ Addedaproba@2.0.0(transitive)
+ Addedare-we-there-yet@2.0.0(transitive)
+ Addedchownr@2.0.0(transitive)
+ Addedcolor-support@1.1.3(transitive)
+ Addedconsole-control-strings@1.1.0(transitive)
+ Addeddebug@4.3.7(transitive)
+ Addeddelegates@1.0.0(transitive)
+ Addeddetect-libc@2.0.3(transitive)
+ Addedemoji-regex@8.0.0(transitive)
+ Addedfs-minipass@2.1.0(transitive)
+ Addedfs.realpath@1.0.0(transitive)
+ Addedgauge@3.0.2(transitive)
+ Addedglob@7.2.3(transitive)
+ Addedhas-unicode@2.0.1(transitive)
+ Addedhttps-proxy-agent@5.0.1(transitive)
+ Addedis-fullwidth-code-point@3.0.0(transitive)
+ Addedmake-dir@3.1.0(transitive)
+ Addedminimatch@3.1.2(transitive)
+ Addedminipass@3.3.65.0.0(transitive)
+ Addedminizlib@2.1.2(transitive)
+ Addedmkdirp@1.0.4(transitive)
+ Addedms@2.1.3(transitive)
+ Addednode-fetch@2.7.0(transitive)
+ Addednopt@5.0.0(transitive)
+ Addednpmlog@5.0.1(transitive)
+ Addedobject-assign@4.1.1(transitive)
+ Addedreadable-stream@3.6.2(transitive)
+ Addedrimraf@3.0.2(transitive)
+ Addedsafe-buffer@5.2.1(transitive)
+ Addedsemver@6.3.17.6.3(transitive)
+ Addedset-blocking@2.0.0(transitive)
+ Addedsignal-exit@3.0.7(transitive)
+ Addedstring-width@4.2.3(transitive)
+ Addedstring_decoder@1.3.0(transitive)
+ Addedstrip-ansi@6.0.1(transitive)
+ Addedtar@6.2.1(transitive)
+ Addedtr46@0.0.3(transitive)
+ Addedutil-deprecate@1.0.2(transitive)
+ Addedwebidl-conversions@3.0.1(transitive)
+ Addedwhatwg-url@5.0.0(transitive)
+ Addedwide-align@1.1.5(transitive)
+ Addedyallist@4.0.0(transitive)
- Removedjava@>=0.14.0
- Removedasync@0.9.0(transitive)
- Removedfind-java-home@0.1.2(transitive)
- Removedglob@5.0.5(transitive)
- Removedjava@5.0.1(transitive)
- Removedminimatch@2.0.10(transitive)
- Removednan@1.7.0(transitive)
- Removedwhich@1.0.9(transitive)