A large part of our work here is integration. We read in data from various sources and send it into Dynamics. On a recent job we were asked to read an Excel spreadsheet and integrate it; this article is a code example of how to do that for Excel 2010 and later formats. In other words, it needs to be an .XLSX file.
The code is heavily commented so it is self explanatory.