Hi,
after using this code
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.
after using this code
CsvFormatProvider formatProvider =
new
CsvFormatProvider();
ofd.Filter =
"CSV (comma delimited) (*.csv)|*.csv|All Files (*.*)|*.*"
;
if
(ofd.ShowDialog() ==
true
)
{
try
{
using
(Stream input = ofd.File.OpenRead())
{
this
.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.