How to import data from an Excel Spreadsheet dynamically

In this tutorial we will show how to import data from an Excel file dynamically, so when the Excel file changes the linked table in your site gets updated automatically. This is very useful when a lot of updates occurs and you want to simply update the external Excel file, instead of recreating the tables in your site.