public ProjectionRatesTab(Excel.Workbook oWB, DataTable newInputPrm, string prjNme) { this.projectionNameOfSummaryTabs = prjNme; this.shts = (Excel.Sheets)oWB.Sheets; this.oSheet = (Excel.Worksheet)this.shts.Add(); this.nwPrm = newInputPrm; SetupSheetNameAndLocationInWorkbook(); OutputAndFormatRateGridAndSubsidy(); FinalizeSheetName(); }
public ProjectionDetailTab(DataTable finalCns, Excel.Workbook oWB, string prjNme) { this.fnlCns = finalCns; this.projectionNameOfSummaryTabs = prjNme; this.shts = (Excel.Sheets)oWB.Sheets; this.oSheet = (Excel.Worksheet)this.shts.Add(); SetupSheetNameAndLocationInWorkbook(); OutputAndFormatRateGridAndSubsidy(); FinalizeSheetName(); }
public ProjectionAssumptionResults(InputOptionsPage inputOptions, Excel.Workbook oWB, string prjNme) { this.inputOptions = inputOptions; this.projectionNameOfSummaryTabs = prjNme; this.shts = (Excel.Sheets)oWB.Sheets; this.oSheet = (Excel.Worksheet)this.shts.Add(); SetupSheetNameAndLocationInWorkbook(); OutputAndFormatInputAssumptions(); FinalizeSheetName(); }
public static NetOffice.ExcelApi.Worksheet AddSheet(this NetOffice.ExcelApi.Sheets sheets) { return((NExcel.Worksheet)sheets.Add()); }
public ProjectionSummaryTab(Tuple<List<string>, DataTable, List<double>, List<string>, DataTable, List<double>> projectionData, Excel.Workbook oWB, string prjNme) { this.projectionNameOfSummaryTabs = prjNme; this.shts = (Excel.Sheets)oWB.Sheets; this.oSheet = (Excel.Worksheet)this.shts.Add(); SetupSheetNameAndLocationInWorkbook(); OutputSummaryResultsAndFormat(projectionData.Item2, projectionData.Item3, 5); //Output for Prior Year OutputSummaryResultsAndFormat(projectionData.Item5, projectionData.Item6, 8); //Output for Current Year FinalizeSheetName(); }