Skip to content

compares a xlsx worbook to a mysql database and applies the changes found in workbook

Notifications You must be signed in to change notification settings

Riz-waan/xlsx-mysql

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

52 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

XLSX-MYSQL

compares a xlsx worbook to a mysql database and applies the changes found in workbook

PLEASE HELP

Since this is my first NPM module and I am only barely familiar with node, this program only barely works. The following things need to be addressed:

  • The function does not return anything, I have tried to make it return something but I was unable to.
  • For now it uses a sleepfunction in the for loop per number of sheets. This is not the best way, and I am sure there is some kind of alternative to fix this.

IF ANYONE OF YOU COULD HELP FIX THIS, THEN PLEASE DO BY ALL MEANS AND OPEN A PULL REQUEST

DESCRIPTION

This project uses two other node modules to upload a xlsx workbook into a mysql database. The following things need to be kept in mind when using:

  • The name of the sheets must be table names in your MYSQL DB.
  • Column names should match exactly.
  • A delimiter needs to be used.
  • If only the last sheet's data is being processed then take a look at the waitT variable and add extra time to allow for the sheet to be processed.

For more information please refer to this link: https://github.com/rajaru/csv-mysql#readme

Installation

yarn add xlsx-mysql

or

npm i xlsx-mysql

Usage

const XLSXtoMYSQL = require('xlsx-mysql');

const optionsZ = {
    locationXLSXtoMYSQL: './export.xlsx',
    optionsXLSXtoMYSQL: {
        mysql: {
            host: '127.0.0.1',
            user: 'root',
            database: 'test',
            password: 'password',
            port: '3306'
        },
        csv: {
            delimiter: '+'
        },
        table: 'xlsx' //table to save XLSX content
    },
}
XLSXtoMYSQL(optionsZ);

License

Apache 2.0

About

compares a xlsx worbook to a mysql database and applies the changes found in workbook

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • JavaScript 100.0%