Clear data from Excel spreadsheet

clear-data-from-Excel-spreadsheet.js

// clear the content of an SLSX file
var aspose = aspose || {};
// create an object of the Cells class.
aspose.cells = require("aspose.cells");
// instantiates WorkBook child class with an XLSX file  
var sampleFile = "sample.xlsx";
var workbook = new aspose.cells.Workbook(sampleFile);
// call clear() method to clear all cell and row objects.
workbook.getWorksheets().get(0).getCells().clear();
// save the data into a new xlsx file
workbook.save("result.xlsx");