I have created a typed dataset (in WPF project) with only one datatable and I should fill it from the given Excel worksheet.

How should I do it? I managed to fill an untyped dataset but I have problems with the typed one.

Let's say my Excel data is in the columns A-E, headings in row 1 and the data starting at row 2. The typed dataset has been created with 5 columns, matching the Excel data columns.