Upload Excel spreadsheet information to Django

General info

This project is an exercise where I make a page who lets upload data stored in a Excel file into the database using Django, SQLite3 and VueJs.

Technologies

Project uses the following dependencies:

Frontend

  • Axios: 0.25.0
  • Bootstrap: 5.1.3
  • Convert-excel-to-json: 1.7.0
  • Vue: 3.0
  • Xlsx: 0.18.0

Backend

  • Django: 4.0.1
  • Django_cors_headers=: 3.11.0
  • Django_environ: 0.8.1
  • Djangorestframework: 3.13.1
  • Environ: 1.0
  • SQLite3

Setup

Install necessary software

  • Node.js.

    You can get Node.js clicking this button
    Nodejs
    or here: https://nodejs.org/es/

    If you already have Node.js installed in your device, just make sure that it is a version higher than 16.13.1.

  • Python.

    You can get Python clicking this button
    Python
    or here: https://www.python.org/downloads/

  • Execute file dependency_installer.sh

    It will install all necessary dependencies, modules and make migrations.

Run App

To run the application you must execute this two files:

  • start_backendserver.sh

  this file run the backend server with Django.

  • start_frontendserver.sh

  this file run the frontend server with Vuejs.

And go to http://localhost:8080/ or http://192.168.0.14:8080/

GitHub

View Github