Coursesity is supported by learner community. We may earn affiliate commission when you make purchase via links on Coursesity.

Certification Course

Python: Easily migrate Excel files to a database

Discount Offer

Go to Course SAVE

0

Students Enrolled

0

(0)

Students Ratings

Already Enrolled this course?

+ Write your review

Automate the reading / writing of Excel document and/or migrate them to a database - Free Course

Course Overview
Reviews

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.