I am trying to import the excel contents to .net datatable with first row as header and other rows having data.
Is there a way to find data type of WorksheetCell or column? Specifically I want to know if the column is DATE datatype.
foreach (Infragistics.Excel.WorksheetRow wkRow in wk.WindowOptions.SelectedWorksheet.Rows) {
foreach (Infragistics.Excel.WorksheetCell wkCell in wkRow.Cells) {
// How to find cell datatype??
}