I am trying to import data in excel file to mysql just like row colon using nodejs
are there any references i can learn or any module in nodejs that does my work or any sample code
I have searched in google but i have seen solutions for only mongodb and for python ,
A few methods which come to my mind:
Save the excel sheet(s) you want to import in csv format, and then import them into mysql : cf. How to import CSV file to MySQL table By far the simplest method, but you might run into trouble with quotes and commas and other idiosyncrasies.