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.