Place data from a spreadsheet in Excel in the database

Question

The database here of the company generates a report in Excel, I need to save this data in a database, initially sqlite3, to be able to display this data in a Django template in the future.

Example of Exel:

Nome do profissional,"Situação atual","Endereco E_Mail","Site","Site 2","Nascimento",
ABDIAS VENCESLAU DA SILVA NETO,"Ativo","[email protected]","","","07/07/1977",

Each of these data would be stored in the respective Django model and in the database.

What would be the best way to do that? Please send suggestions!

Answer 1

Try it this way

py.models

class Funcionario(models.Model):
    nome = models.CharField(max_length=255),
    situacao = models.BooleanField,
    email = models.CharField(max_length=255)
    site = models.CharField(max_length=255)
    site2 = models.CharField(max_length=255)
    nascimento = models.DateField()

services.py (or any other file)

class ImportToDatabase(object):

    @staticmethod
    def import_data():
        with open('relatorio.csv') as csvfile:
            reader = csv.reader(csvfile, delimiter=',')
            for row in reader:
                obj, created = Funcionario.objects.get_or_create(
                    nome=row[0],
                    situacao=row[1],
                    email=row[2],
                    site=row[3],
                    site2=row[4],
                    nascimento=row[5]
                )

py views.

ImportToDatabase.import_data()

If you want to use the Function object it is loaded in the obj variable To know if the record has been inserted or loaded, use the boolean variable "created".