public static bool dayCheck(string strValue) { bool boolRetVal = false; if (strValue.Length > 0) { if (strValue.Length == 19) { //if (CommonExcelClasses.IsDate(strValue)) if (CommonExcelClasses.IsDate(strValue)) { string strDayOfWeek = FormatDate(DateTime.Parse(strValue), "dddd"); boolRetVal = (strDayOfWeek == "Monday" || strDayOfWeek == "Tuesday" || strDayOfWeek == "Wednesday" || strDayOfWeek == "Thursday" || strDayOfWeek == "Friday"); } } } return(boolRetVal); }
/// <summary> /// Clear the workbook /// </summary> public static void zapWorksheet(Excel.Worksheet Wks, int intFirstRow = 2) { Excel.Range xlCell; // Wks = Wkb.ActiveSheet; int intLastRow = CommonExcelClasses.getLastRow(Wks); xlCell = Wks.get_Range("A" + intFirstRow + ":A" + intLastRow); if (Wks.Name != "InternalParameters") { if (intLastRow > intFirstRow) { xlCell.EntireRow.Delete(Excel.XlDirection.xlUp); } } else { CommonExcelClasses.MsgBox("Cannot run in worksheet: InternalParameters", "Error"); } }