Populate Typed DataSet

Aspose.Cells Product Family
1

I am currently reading in data from an excel spreadsheet using the Jet OleDb driver. I read the data in using a data adapter to populate a typed DataSet. I also using TableMappings so I can map Excel column A to typed DataSet column Name. However, I am now having issues using the Jet driver when columns are formatted different ways. I have not seen this issue when using Aspose.Excel for other purposes. I was wondering if there is a way I can use Aspose.Excel to populate a typed DataSet using TableMappings.

Thank you,

Jarrod

2

Hi Jarrod,

In Aspose.Excel, you can use Cells.ExportDataTable method to export data in an Excel file to a DataTable. Could it serve your need?