Limitations and API Differences

Public API Differences

The following list (with sample code segments) shows some differences between Aspose.Cells for Java and Aspose.Cells for Node.js via Java APIs.

Importing library (Package Comparisons)

Aspose.Cells for Java

 import com.aspose.cells.*;

Aspose.Cells for Node.js via Java

 var aspose = aspose || {};

aspose.cells = require("aspose.cells.java");

Instantiating a new Workbook

Aspose.Cells for Java

 Workbook excelbook = new Workbook();

Aspose.Cells for Node.js via Java

 var excelbook = new aspose.cells.Workbook();

Enums or Constants

Aspose.Cells for Java

 arc2.getLineFormat().setDashStyle(MsoLineDashStyle.SOLID);

Aspose.Cells for Node.js via Java

 arc2.getLineFormat().setDashStyle(aspose.cells.MsoLineDashStyle.SOLID);

Streaming Files

Aspose.Cells for Java

 InputStream inputstream = new FileInputStream(“Book1.xlsx”);

Workbook workbook = new Workbook(inputstream);

workbook.save(“result.xlsx”);

Aspose.Cells for Node.js via Java

 var aspose = aspose || {};

aspose.cells = require("aspose.cells.java");

var fs = require("fs");

var readStream = fs.createReadStream("Book1.xlsx");

aspose.cells.Workbook.createWorkbookFromStream(readStream, function(workbook, err) {

    if (err) {

        console.log("open workbook error");

        return;

    }

   workbook.save('result.xlsx');

    console.log('saved to file');

});

Other Limitations of Aspose.Cells for Node.js via Java API compared to Aspose.Cells for Java API

1. Importing/exporting data from an Array, ArrayList, ResultSet etc. is not supported.
2. Printing is not supported.