Python: Easily migrate Excel files to a database

Description

Reading data from Excel documents.

Writing data to Excel documents.

Migrate data from Excel documents to a database.

In this course there will first be a basic introduction to openpyxl: the ideas behind reading and writing data from and to Excel. After this we will see how to read from multiple Excel documents and save them to a database. The database could be any relational database, but for this course we will use SQLite.

Show more