How to export database data to excel file using node.js?

Question

How can i export the table stored in a database into an excel file using node.js? I don't know how to build connection with the database and create a table in excel that looks like the table in database.

table

Thanks

This is highly dependent on the shape of your data.

chrisbajorin
– chrisbajorin

2016-06-28 14:39:47 +00:00
Commented Jun 28, 2016 at 14:39 — chrisbajorin
– chrisbajorin, Commented Jun 28, 2016 at 14:39

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

I'm not an expert in node.js, but regarding the Excel part of your question: if you don't need a very complex sheet, then the simplest thing is to output the information in a command separated list, like:

header1,header2,...

value1,value2,...

Save it as .csv and Excel will be able to open it.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jun 28, 2016 at 14:10

Daniel SH

1431 silver badge9 bronze badges

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

Collectives™ on Stack Overflow

How to export database data to excel file using node.js?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related