How to extract data from Microsoft Excel XML Files

Today I want to show how to extract data from Microsoft Excel Files. I needed it myself the time I looked for a solution to create some testdata for my application. Instead of putting the testdata into a database - which would be very hard to handle - I decided to put them into an Excel file.