I need to import a spreadsheet into a dataset. The spreadsheets have rows and columns of data, but some of the columns are totaled at the bottom. I think this is giving me error when trying to use the DataTableFormatProvider.Export.
So I want to open the file and read the cells row by row. Are there any examples on how to open a spreadsheet and walk through it row by row?