NodeExcelMssql

Installation

npm install --save-dev nodeexcelmssql

How To Use

import { importFromExcelToMssql } from 'nodeexcelmssql'

const dbinfo = {
  server: "<<database-hostname>>",
  username: "<<database-username>>",
  password: "<<database-password>>",
  database: "<<database-schema>>"
}
importFromExcelToMssql(dbinfo, "/path/to/excel.xlsx")

## Create Data Excel
- Input table name to sheet name.
- On column A input "columns::", the row is for columns.
- On column A input "data::", From the next row, for datas.

## Supported SQLServer Types
- TinyInt
- SmallInt
- Int
- BigInt
- Decimal
- Numeric
- Money
- SmallMoney
- Float
- Real
- Date
- Time
- 
DateTime2
- DateTimeOffset
- DateTime
- SmallDateTime
- Char
- VarChar
- Text
- NChar
- NVarChar
- NText
- Binary
- VarBinary
- Image