public ModelSheet Add(Utilities.EnergySource aSource) { Excel.Worksheet thisSheet = (Excel.Worksheet)Globals.ThisAddIn.Application.ActiveWorkbook.Worksheets.Add (System.Type.Missing, Globals.ThisAddIn.Application.ActiveWorkbook.Sheets.get_Item(Globals.ThisAddIn.Application.ActiveWorkbook.Sheets.Count), 1, Excel.XlSheetType.xlWorksheet); thisSheet.CustomProperties.Add("SheetGUID", System.Guid.NewGuid().ToString()); thisSheet.Name = Utilities.ExcelHelpers.CreateValidWorksheetName(Globals.ThisAddIn.Application.ActiveWorkbook, aSource.Name, Globals.ThisAddIn.groupSheetCollection.regressionIteration); thisSheet.Tab.Color = 0x50CC11; thisSheet.Visible = Excel.XlSheetVisibility.xlSheetHidden; string sheetString = thisSheet.ToString(); GroupSheet GS = new GroupSheet(thisSheet, false, false, thisSheet.Name); Globals.ThisAddIn.groupSheetCollection.Add(GS); ModelSheet aSheet = new ModelSheet(thisSheet); aSheet.Source = aSource; return(aSheet); }
public void plotEnPI(Excel.ListObject LO) { groupSheetCollection = new GroupSheetCollection(); groupSheetCollection.PlantName = ((Excel.Worksheet)LO.Parent).Name; groupSheetCollection.WB = (Excel.Workbook)((Excel.Worksheet)LO.Parent).Parent; groupSheetCollection.WBName = groupSheetCollection.WB.Name; masterGroupCollection.Add(groupSheetCollection); groupSheetCollection.regressionIteration = masterGroupCollection.WorkbookNextIteration(groupSheetCollection.WB); // create a data table with the data to be adjusted object[,] sourcerows = ExcelHelpers.getYearArray(LO, Years); DataTable dtSourceData = DataHelper.ConvertToDataTable(LO.HeaderRowRange.Value2 as object[, ], sourcerows); EnPIData = new EnPIDataSet(); EnPIData.WorksheetName = ((Excel.Worksheet)LO.Parent).Name; EnPIData.SourceData = dtSourceData; EnPIData.ListObjectName = LO.Name; EnPIData.BaselineYear = BaselineYear; EnPIData.ModelYear = SelectedYear; EnPIData.ReportYear = ReportYear; //Added By Suman for SEP Changes EnPIData.Years = Years.Cast <string>().ToList(); if (Utilities.Constants.MODEL_TOTAL) { SelectedSources.Add(rsc.GetString("unadjustedTotalColName")); } EnPIData.EnergySourceVariables = SelectedSources; EnPIData.IndependentVariables = SelectedVariables; EnPIData.ProductionVariables = SelectedProduction; EnPIData.BuildingVariables = SelectedBuildings; EnPIData.Init(); ModelSheets = new ModelSheetCollection(); foreach (Utilities.EnergySource src in EnPIData.EnergySources) { ModelSheet aSrc = ModelSheets.Add(src); aSrc.Populate(); aSrc.WS.Visible = Excel.XlSheetVisibility.xlSheetVisible; } AdjustedDataSheet adjData = new AdjustedDataSheet(EnPIData); adjData.Populate(true); EnPISheet results = new EnPISheet(EnPIData, false); results.AdjustedDataSheet = adjData.thisSheet; results.AdjustedData = adjData.AdjustedData; results.Populate(); //EnPISheet senpiresults = new EnPISheet(EnPIData, true); //senpiresults.AdjustedDataSheet = adjData.thisSheet; //senpiresults.AdjustedData = adjData.AdjustedData; //senpiresults.Populate(); SEPSheet sepResults = new SEPSheet(EnPIData); sepResults.AdjustedDataSheet = adjData.thisSheet; sepResults.AdjustedData = adjData.AdjustedData; sepResults.Populate(); if (Globals.ThisAddIn.wizardPane.Visible) { Globals.ThisAddIn.hideWizard(); } // cleanup ExcelHelpers.Cleanup(Globals.ThisAddIn.Application.ActiveWorkbook); }