after using this code
CsvFormatProvider formatProvider =
"CSV (comma delimited) (*.csv)|*.csv|All Files (*.*)|*.*"
(Stream input = ofd.File.OpenRead())
.spreadsheet1.Workbook = formatProvider.Import(input);
One of my entries in the csvfile has a value of 001-01. In the spreadsheet, i see the value of Jan-01. The value is totally wrong and really don't know where is the problem on my side. Any idea? How can i get around this error?
Attached to this thread, you'll find a snapshot of the csv file. Look at the SCRNNUM, SUBJID columns.