Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
215
Infragistics Excel WorksheetCell -- import to datatable (DATE column)
posted

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??

                  }

 }