public static object CALIsBizDay(string calName, int serialNumber) { try { DateUtilities.CALCalendar cal = new DateUtilities.CALCalendar(calName); DateUtilities.CALDate calDate = new DateUtilities.CALDate(serialNumber); return(cal.IsBizDay(calDate)); } catch (Exception e) { return(Utilities.ExcelRangeErrorString(e)); } }
public static object CALDateAdvance(string calName, int serialNumber, string periodrepr, object covrepr, object endOfMonth) { try { //if (ExcelDnaUtil.IsInFunctionWizard()) // return "!!! In FunctionWizard"; DateUtilities.CALCalendar cal = new DateUtilities.CALCalendar(calName); DateUtilities.CALDate calDate = new DateUtilities.CALDate(serialNumber); string cStr = Utilities.Check(covrepr, "Following"); bool eom = Utilities.Check(endOfMonth, false); return(cal.DateAdvance(calDate, periodrepr, cStr, eom).SerialNumber()); } catch (Exception e) { return(Utilities.ExcelRangeErrorString(e)); } }
public static object CALBizDatesList(string calName, int start, int end) { try { //if (ExcelDnaUtil.IsInFunctionWizard()) // return "!!! In FunctionWizard"; DateUtilities.CALCalendar cal = new DateUtilities.CALCalendar(calName); DateUtilities.CALDate beginDate = new DateUtilities.CALDate(start); DateUtilities.CALDate endDate = new DateUtilities.CALDate(end); DateUtilities.CALDate[] dateList = cal.BizDatesList(beginDate, endDate); double[,] ret = new double[dateList.Length, 1]; for (int i = 0; i < dateList.Length; ++i) { ret[i, 0] = (double)dateList[i].SerialNumber(); } return(Utilities.ArrayResizer.ResizeDoubles(ret)); } catch (Exception e) { return(Utilities.ExcelRangeErrorString(e)); } }