NodeExcelMssql

Installation

``
npm install --save-dev nodeexcelmssql
`

How To Use

``
import { importFromExcelToMssql } from 'nodeexcelmssql'

const dbinfo = {
server: "<>",
username: "<>",
password: "<>",
database: "<>"
}
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