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();
}
