Uploadexjs – Import Excel File into MYSQL with Expressjs




If demo on preview is not working, please test demo directly to the site.

Uploadexjs is a web app build with expressjs and MYSQL database. This apps have some simple feature but very useful for your Database or Datawarehouse concerns. In accordance with the title, this app can upload your existing excel file with format .xlsx or .xls into database MYSQL. It can use upload multiple files, but developer limit 5 files for server optimized reason. It has some feature too.

Feature :
1. Import excel file to Mysql DB
2. Upload multiple excel file into DB
3. Check duplicate data
4. Grouping data
5. Chart data monitor
6. Paging

To Upload the excel file you must follow below rules:

1. excel file must use extention file .xls and .xlsx
2. excel file must contain header.
3. header file should not contain space. Example if you put Phone Number, please use PhoneNumber or Phone_Number instead of Phone Number
4. don’t let empty cell. Let say you have 5 colum & 10 rows. Please make sure all cell is filled. If empty cell is number, then set 0. If empty cell is string then set none. You cannot fill first column with 10 record, second column with 5 record.
5. don’t use quote(‘) and double quote(“) inside of the cell.

If you dont follow above rules, you might be get an error.

Update version 1.1:

1. Add feature delete list
2. Update styling
3. Paging styling
4. Update documentation

Default login:
username : ekas
password : 1234