×Welcome aboard! We are happy you are here and wish you good net-raft!

Together We Can Simplify The World

the current number of solutions:  2304
 (1x)    .htaccess (1x)    AJAX (13x)    ANGULARJS (157x)    ASP (1x)    ASP.NET (4x)    BACKBONE.JS (47x)    BOOTSTRAP (12x)    C# (216x)    COFFEESCRIPT (28x)    CSS (71x)    HTML (47x)    JADE (32x)    JAVA (51x)    JAVASCRIPT (426x)    JQUERY (377x)    JQUERY MOBILE (5x)    JSON (5x)    LARAVEL (23x)    MYSQL (9x)    NODEJS (155x)    ORACLE SQL (19x)    PERL (1x)    PHP (293x)    PYTHON (9x)    REACT (61x)    RUBY (23x)    RUBY ON RAILS (1x)    SHELL (1x)    SQL (90x)    SQL SERVER (3x)    TYPESCRIPT (50x)    VB.NET (26x)    W3.CSS (6x)    W3.JS (40x)    
join us

click to create your account

mysql output to excel nodejs

(nodejs mysql output excel )


 viewed 40



// the structure of MYTABLE
// Name Age
// Jack 25
// John 33
// Steve 31

var mysql = require('mysql');

var con = mysql.createConnection({
host: "localhost",
user: "root",
password: "xxx",
database: "xxx"

con.connect(function(err) {

if (err) throw err;
console.log("the connection is open!");

con.query("SELECT * FROM MYTABLE", function (err, result) {
if (err) throw err;

var fs = require('fs');
var writeStream = fs.createWriteStream("file.xls");
var header = "Name"+" "+"Age"+" ";
var row1 = "";

for (y = 0; y < result.length; y++) {

row1 = row1 + result[y].name + " " + result[y].age + " ";


writeStream.write(header + row1);

if (!writeStream )
console.log('something went wrong!');
console.log('the excel successfully created!"');




created: 25 days ago

The power of the user (%)


Do you know a little more effective code ? Feel free to optimize ...

haven't you found what you're looking for ?
Write us your question ...
Login is not needed.

The most helpful NODEJS solutions
Likes Solution Technology
1.3K get user ipNODEJS
299 how to get client netmask using node.js ?NODEJS
264 how to get client local ip address using node.js ?NODEJS
239 How to combine node.js and jquery ?NODEJS
231 How to get client ip address using node.jsNODEJS
Check out all of NODEJS ...
The most viewed NODEJS solutions by country
Solution Country
detect mobile nodejsCinque Terre
check if email is valid nodejsCinque Terre
How to get client ip address using node.jsCinque Terre
How to get client ip address using node.jsCinque Terre
How to get client ip address using node.jsCinque Terre