string is nog recognized as a valid DateTime

Cassie Mod

10y1.1kVisual Basic .NET

HI i made the followin class to get dates from an excel file.

file:

col:a col:b col:c

1. X-mas 2015-19-12 2016-03-01

2. carnaval 2016-20-02 2016-28-02

using System;
using OfficeOpenXml;
using System.IO;
namespace CalviVsTribessCheck.Cmd
{
public static class ExcelFileDataAccess
{
public static void ReadExcelFile(DateTime start)
{
var filePath = @"c:\code\Tools\Development\RtcMonitoring\RatingTribessCheck.Cmd\Vacations.xlsx";
var sheetName = "vacations";
using (var excelPkg = new ExcelPackage())
using (var stream = new FileStream(filePath, FileMode.Open))
{
excelPkg.Load(stream);
ExcelWorksheet oSheet = excelPkg.Workbook.Worksheets[sheetName];
var totalRows = oSheet.Dimension.End.Row;
for (var i = 1; i <= totalRows; i++)
{
var vacationbegindate = DateTime.Parse((oSheet.Cells[i, 1]).Value.ToString());
var vacationenddate = DateTime.Parse((oSheet.Cells[i, 2]).Value.ToString());
BusinessLogic.CheckVacation(start, vacationbegindate, vacationenddate);
}
}
}
}
}

however i get the following error when converting a cell value to a dateTime:

The string is not recognized as a valid DateTime. Index 0 begins with an unknown word

How can i fix this ???? please provide me with your answer

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Cassie Mod10y ago
thnx guys,

thnx for your answers. It helped a lot and it is fixed now so thank you all for that.

The answer was like Rajeev Punhani told( only a bit difference when i used value i got a value like 42364 ??? so..).

var vacationbegindate = DateTime.ParseExact((oSheet.Cells[i, 2]).Text, "yyyyddMM", null);
Rajeev Punhani10y ago
Hi Cassie,

Please try the below

DateTime vacationbegindate= DateTime.ParseExact((oSheet.Cells[i, 1]).Value.ToString(), "yyyy-dd-MM", null);
If the above solution is helpful then,accept the answer.

Banketeshvar Narayan10y ago

You can use DateTime.ParseExact or DateTime.TryParseExact method for that Below are some code samples:

Ex 1:

DateTime.TryParseExact(txtStartDate.Text, formats, 
System.Globalization.CultureInfo.InvariantCulture, DateTimeStyles.None, 
out startDate)

Ex 2:

CultureInfo provider = CultureInfo.InvariantCulture; DateTime result; 
dateString = "Sun 08 Jun 2013 8:30 AM -06:00"; 
format = "ddd dd MMM yyyy h:mm tt zzz"; 
result = DateTime.ParseExact(dateString,format, provider);

Rajeesh Menoth10y ago
Hi,

Check the following reference :

http://www.c-sharpcorner.com/code/1459/string-was-not-recognized-as-a-valid-datetime.aspx