项目作者: kzelda

项目描述 :
Export excel file to Sql inserts
高级语言: JavaScript
项目地址: git://github.com/kzelda/xlsx-sql.git
创建时间: 2019-10-15T10:28:52Z
项目社区:https://github.com/kzelda/xlsx-sql

开源协议:

下载


xlsx-sql

Without installing (using npx)

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

OR

Global installation

  1. yarn global add xlsx-sql
  2. # or using npm
  3. npm install -g xlsx-sql
  4. # you can now use it like
  5. xlsx-sql xlsx_filename [optional_sql_filename]

OR

Local installation

  1. // npm install xlsx-sql
  2. const xlsx = require("xlsx-sql");
  3. xlsx.Sql(`${__dirname}/file1.xlsx` , `${__dirname}/Script_${Math.random()}.sql`);