how to use createAndFillWorkbook() in exceljs?

javascript exceljs
Monece Solis picture Monece Solis · Apr 29, 2015 · Viewed 9.4k times · Source

I followed the documentation

var workbook = createAndFillWorkbook();

and I get this error Object # has no method 'createAndFillWorkbook'

even if I required exceljs already

var Excel = require("exceljs");

What I wanted to do was to create a report but I am somehow confused on the documentation because it does not say here how to use the createAndFillWorkbook() method it just says here to use it right away.

I referred here in the documentation: https://github.com/guyonroche/exceljs#writing-xlsx

Answer

easywaru picture easywaru · May 21, 2015

createAndFillWorkbook(); does not mean a function.(maybe pseudo function)

You must create some workbook then fill content.

See below.

// create workbook by api.
var workbook = new Excel.Workbook();

// must create one more sheet.
var sheet = workbook.addWorksheet("My Sheet");

// you can create xlsx file now.
workbook.xlsx.writeFile("C:\\somepath\\some.xlsx").then(function() {
    console.log("xls file is written.");
});

Related questions

Add rows before the column header using excel.js module + node

I am trying to create xslx file using excel.js module in node.js. I was able to create the columns and add its values. But, I need to insert some rows before the columns headers, where I can have …

Read More
Creating excel file and writing to it with ExcelJS

I wrote a script that creates a new excel file with ExcelJS. Adds 3 headers and inserts 2 rows. Then saves that file to disk. In the next step it should read that previously saved file, add 1 row and save it again …

Read More
How can I remove a specific item from an array?

I have an array of numbers and I'm using the .push() method to add elements to it. Is there a simple way to remove a specific element from an array? I'm looking for the equivalent of something like: array.remove(…

Read More