Skip to content

kzelda/xlsx-sql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

20 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

xlsx-sql

Without installing (using npx)

npx xlsx-sql <xlsx_file> [optional_sql_file]
# example 1
npx xlsx-sql "c:\tmp\file.xlsx" "c:\tmp\script.sql"
# example 2 (only xlsx file)
npx xlsx-sql "c:\tmp\file.xlsx"

OR

Global installation

yarn global add xlsx-sql
# or using npm
npm install -g xlsx-sql
# you can now use it like
xlsx-sql xlsx_filename [optional_sql_filename]

OR

Local installation

// npm install xlsx-sql
const xlsx = require("xlsx-sql");

xlsx.Sql(`${__dirname}/file1.xlsx` , `${__dirname}/Script_${Math.random()}.sql`);

About

Export excel file to Sql inserts

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published