Using exceljs node package create xlsx file

Question

I am using exceljs 3.8 to create new xlsx file but some reason below code not working ?

     createNewExcelFile:  function (excelFilePath) {
           //excelFilePath: Provide path and file name for excel file
           // load exceljs module
           var workbook = new exceljs.Workbook(); //create object of workbook
           //add sheet to workbook
           var newSheet = workbook.addWorksheet('TestData');
           //use write file function to create new file
           workbook.xlsx.writeBuffer(excelFilePath) 
               .then(function () {
                   console.log("excel file created successfully");
               });
       }

createNewExcelFile('new1.xlsx');

console.log is logging "excel file created successfully" but i don't see any where file getting created.

Paweł Siemienik · Accepted Answer · 2020-04-29 17:32:11Z

2

1. You should use `writeFile` instead of `writeBuffer`

workbook.xlsx.writeFile(excelFilePath);

(Source: https://github.com/exceljs/exceljs#writing-xlsx)

2. `xlsx-renderer`

I would also recommend using xlsx-renderer which provides generating excel files based on Template and ViewModel.

Template + ViewModel = Preaty XLSX

Template:

VM:

{
"projects": [
    {
        "name": "ExcelJS",
        "role": "maintainer",
        "platform": "github",
        "link": "https://github.com/exceljs/exceljs",
        "stars": 5300,
        "forks": 682
    },
    {
        "name": "xlsx-import",
        "role": "owner",
        "platform": "github",
        "link": "https://github.com/siemienik/xlsx-import",
...

Gives:

This library will work great with your code because it based on ExcelJs too.

(Source: https://github.com/Siemienik/xlsx-renderer/tree/master/tests/integration/data/Renderer009-ForEach-Average)

EDIT: (29.04.2020) In the practice it's used by the following code:

const result = await renderer.renderFromFile('./report-template.xlsx', { awesome:"Oh yeah!", items:[/*...*/]});
await result.xlsx.writeFile('./my-awesome-report.xlsx');

edited Apr 29, 2020 at 17:32

answered Apr 28, 2020 at 11:56

Paweł Siemienik

686 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

jsduniya Over a year ago

So you mean this library automatically create file and add data into it..no need to create any empty excel also ?

Paweł Siemienik Over a year ago

Yeah, it uses the template that was prepared before. And put data into a cell with value started by ##. It has the possibility to looping / inserting hyperlinks and many more. It's really fine because allow easily change the template without any code changes. For example, always when a company change visual identification. I've added also into the post above code how to use it. It's will be available as a restful microservice under docker soon.

Collectives™ on Stack Overflow

Using exceljs node package create xlsx file

1 Answer 1

1. You should use `writeFile` instead of `writeBuffer`

2. `xlsx-renderer`

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1. You should use writeFile instead of writeBuffer

2. xlsx-renderer

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related

1. You should use `writeFile` instead of `writeBuffer`

2. `xlsx-renderer`