how to use createAndFillWorkbook() in exceljs?

Question

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

score 11 · Accepted Answer · answered May 21 '15 at 07:13

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.");
});

score 5 · Answer 2 · answered Aug 31 '16 at 06:45

5

var excel = require("exceljs");
var workbook1 = new excel.Workbook();
workbook1.creator = 'Me';
workbook1.lastModifiedBy = 'Me';
workbook1.created = new Date();
workbook1.modified = new Date();
var sheet1 = workbook1.addWorksheet('Sheet1');
var reColumns=[
    {header:'FirstName',key:'firstname'},
    {header:'LastName',key:'lastname'},
    {header:'Other Name',key:'othername'}
];
sheet1.columns = reColumns;
workbook1.xlsx.writeFile("./uploads/error.xlsx").then(function() {
    console.log("xlsx file is written.");
});

This is my sample code which works for me.

answered Aug 31 '16 at 06:45

Karthik

129
2
8

what if I want to fill the rows inside each column? – yogieputra Apr 09 '17 at 02:08
@Liverpool - did you figured out how to do it ? I also want to do the samething – PulkitG Jul 06 '17 at 06:23
2

To add rows: `sheet1.addRows([{firstname: "Name", lastname: "Last", othername: "Other"}])` – tokland Feb 06 '18 at 22:42
does this work on Angular 5 or Angular 2? Because I am getting this error: Uncaught TypeError: Cannot read property 'prototype' of undefined. – Artanis Zeratul Aug 30 '18 at 02:56
This is for [tag:node.js] – ashleedawg Oct 23 '20 at 09:38

how to use createAndFillWorkbook() in exceljs?

2 Answers2