Append data in excel file column wise in nodejs

Question

I am working to append data in csv file using fs.appendFileSync. I can easily append the data row wise but i can't find any way to append data in excel file column wise. For example, first fill column 'A' with data then column 'B' and so on. I am wondering if some one help me in this regard. Thanks in advance!

Possible duplicate of How to add new column to csv file using node js — jhenderson2099
– jhenderson2099, Commented Nov 18, 2017 at 21:11

hlozancic · Accepted Answer · 2017-11-18 20:21:53Z

0

It will be very hard to do this task using fs.appendFileSync. Also, try not to use SYNC methods whenever possible.

For your problem I would recommend this npm module: https://www.npmjs.com/package/exceljs

You can manipulate excel files using it. To add a rows and columns, just check docs. For example: https://www.npmjs.com/package/exceljs#rows

answered Nov 18, 2017 at 20:21

hlozancic

1,49918 silver badges31 bronze badges

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

2 Comments

farfer Over a year ago

thanks a lot for your instant answer. I will check the module and will let you know if i need further help. Thanks

farfer Over a year ago

i have seen that it also add data in a array which is added as a row which somehow i able to do it but how column wise. Any way?

Collectives™ on Stack Overflow

Append data in excel file column wise in nodejs

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related