public void printToExcel(string path1, string sheetname) { ExcelWrapper ew = new ExcelWrapper(); if (ew.Open(path1) == false) { return; } Excel.Worksheet mySheet; mySheet = ew.CreateSheet(sheetname); if (mySheet == null) { ew.Close(); return; } mySheet.Range["A1:HA500"].Clear(); ew.printLine(); ew.printListPercent(rlist); ew.printLine(); ew.printArrayPercent("MID3-4 : %SP values (this means how many times does each %SP appear in the List)", temp); ew.printLine(); ew.printLine("max %SP value : " + maxSpcCount.ToString()); ew.printLine(); ew.printArrayPercent("MID3-4 :(Choose %SPs' that have max %SP value) ", perTemp); ew.printLine(); for (int i = 0; i < perTemp.Length; i++) { if (perTemp[i] > 0) { // get interval double intmin, intmax; intmax = (i + 1) * Common.GpspInterval; intmin = intmax - Common.GpspInterval; string pns = ""; pns = "Interval(%SP): " + (intmin).ToString("###0.0") + "% ~ " + intmax.ToString("###0.0") + "% , "; pns += " PN's : "; // get PNs between intmax and intmin for (int j = 0; j < rd.Cols; j++) { double persp = rd.PerSP[j]; if (persp > intmin && persp <= intmax) { pns += ((j + 1).ToString()) + " "; } } ew.printLine(pns); } } ew.printLine(); ew.printArray("MID3_4: Result:", mid3_4); ew.printLine(); ew.printLine(); ew.printArray("MID3_4: RANK:", rank3_4); ew.printLine(); ew.Save(); ew.Close(); }