1.0.2 • Published 4 years ago

excel-to-database v1.0.2

Weekly downloads
1
License
MIT
Repository
github
Last release
4 years ago

excel-to-database

Installation


npm install -g excel-to-database

How to use


Example

excelTransfer -d mongo -c mongodb://localhost/local -s C:sheet.xlsx

-d is database, only mongo is available in the moment (default)
-c is connection string
-s is the path to the worksheet (supports only xlsx in the moment)

The worksheet format examples


insert

spreedsheet format example 1

update

spreedsheet format example 2


Versions

1.0.0

  • Base

1.0.1

  • Removed mongo warning
  • Readme updated

1.0.2

  • Fixed spelling errors
  • Fixed connection string to lower case
  • Mongo as default database