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(); }
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:HA200"].Clear(); ew.printLine(); int[] temp = new int[rd.Cols]; if (mid3_1_Count == 1) { for (int i = 0; i < rd.Cols; i++) { temp[i] = mid3_1[0, i]; } ew.printArray("Mid-3-1: Result: ", temp); } else { for (int k = 0; k < mid3_1_Count; k++) { for (int i = 0; i < rd.Cols; i++) { temp[i] = mid3_1[k, i]; } ew.printArray("Mid-3-1-" + (k + 1).ToString() + ": Result: ", temp); } } ew.printLine(); ew.printLine("MID3 RANK:"); ew.printLine(); ew.printArray("RANK:", rank); ew.printLine(); ew.Save(); ew.Close(); }
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:HA200"].Clear(); ew.printLine(); ew.printArray("MID4_1 :Rawdata %SP ", rd.PerSP); ew.printLine("MID4_1: Average %SP : " + rd.APerSP.ToString("#####0.00")); ew.printLine(); ew.printArray("MID4_1 :MX/MN", mx_mn); ew.printLine(); // pn list string[] header = new string[] { "MX+A%SP PN's List", "MX-A%SP PN's List", "MN+A%SP PN's List", "MN-A%SP PN's List" }; int index = 0; foreach (R1pn r1 in rlist.rList) { ew.printLine(header[index] + " : " + r1.getString()); index++; if (index == 4) { break; } } ew.printLine(); ew.printArray("MID4_1: Result:", mid4_1); ew.printLine(); ew.Save(); ew.Close(); }
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:HA200"].Clear(); ew.printLine(); ew.printArray("MID2 :(PN's Count) ", temp); ew.printLine(); ew.printLine(); ew.printArray("MID2 :(Mid_2) ", mid2); ew.printLine(); ew.Save(); ew.Close(); }
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:HA200"].Clear(); /* * ew.printLine("MID3_2_Table Print ------------------------------------"); * for (int i = 0; i < t.Rows; i++) * { * for (int j = 0; j < t.Cols; j++) * { * ew.print(t.table[i, j].ToString("##0.0")); * } * ew.printLine(); * } * ew.printLine(); */ ew.printLine("MID3_2_Table AVERAGE ------------------------------------"); for (int j = 0; j < t.Cols; j++) { ew.print(t.avg[j].ToString("##0.00")); } ew.printLine(); ew.printLine(); // sw.WriteLine("MID3_2_Table: MaxIndex : "+maxindex.ToString()); ew.printLine("MID3_2_Table: MaxAVG : " + t.maxavg.ToString("####0.00")); ew.printLine("MID3_2_Table: interval lower : " + intmin.ToString()); ew.printLine("MID3_2_Table: interval upper : " + intmax.ToString()); ew.printLine(); ew.printArray("MID3_2: Result:", mid3_2); ew.printLine(); ew.Save(); ew.Close(); }
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:HA200"].Clear(); mySheet.Range["A1:AZ4000"].Clear(); ew.printLine(); ew.printLine("Mid_1(RawData.SPC) Print ------------------------------------"); ew.printArray("MID1 :(SPC, sum of 1's ) ", rd.spc); ew.printLine("Mid_1(Max SPC value) : " + maxSPC); ew.printLine("Mid_1(sum of SPC) : " + sumofSPC); string pns = ""; for (int i = 0; i < rd.spc.Length; i++) { if (rd.spc[i] >= maxSPC) { pns = pns + (i + 1).ToString() + " "; } } ew.print("Mid_1(Max PN's) : " + pns); ew.printLine(); ew.printLine("Mid_1(RawData %SPC) Print ------------------------------------"); ew.printArray("MID1 :(%SP) ", rd.PerSP); ew.printLine("MID1 :(A%SP):" + rd.APerSP.ToString("######0.00")); ew.printLine(); ew.printRankArray("MID1 : Rank ", rd.spc); ew.printLine(); ew.printArray("MID1 :(Mid_1) ", mid1); ew.printLine(); // Print Raw Data /* * ew.printLine(); * ew.printLine("Mid_1(RawData Print) ------------------------------------"); * ew.print("POSN"); * for (int i = 0; i < rd.Cols; i++) * ew.print((i + 1).ToString()); * ew.printLine(); * * for (int i = 0; i < rd.Rows; i++) * { * ew.print((i + 1).ToString()); * for (int j = 0; j < rd.Cols; j++) * { * if (rd.rawdata[i, j]==0) * ew.print(" "); * else * ew.print(rd.rawdata[i, j].ToString()); * } * ew.printLine(); * if (i % 100 == 0) * Console.WriteLine(" MID1: Print Line: " + i.ToString()); * } * ew.printLine(); */ ew.Save(); ew.Close(); }
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:AZ400"].Clear(); ew.printLine(); // Print Data // MX List string one = ""; ew.printLine("MX PN List : (PN, %SP) , Count: " + MXPlusCount.ToString()); for (int i = 0; i < MXPlusCount; i++) { one = one + "(" + (MXPlusPN[i] + 1).ToString() + ":" + MXPlus[i].ToString("#####0.00") + ") "; if (i > 0 && i % 5 == 0) { ew.printLine(one); one = ""; } } if (one != "") { ew.printLine(one); } // MN List ew.printLine(); one = ""; ew.printLine("MN PN List : (PN, %SP), Count: " + MXMinusCount.ToString()); for (int i = 0; i < MXMinusCount; i++) { one = one + "(" + (MXMinusPN[i] + 1).ToString() + ":" + (MXMinus[i] * -1).ToString("#####0.00") + ") "; if (i > 0 && i % 5 == 0) { ew.printLine(one); one = ""; } } if (one != "") { ew.printLine(one); } ew.printLine(); // average //ew.printLine("AveMX%SP = " + MXavg.ToString("#######0.00") + " Range:+/-" + (variation * 100).ToString() + "% (" + lower1.ToString("######0.00") + "~" + upper1.ToString("######0.00") + ")"); //ew.printLine("AveMN%SP = " + (MNAvg * -1).ToString("#######0.00") + " Range:+/-" + (variation * 100).ToString() + "% (" + (lower2 * -1).ToString("######0.00") + "~" + (upper2 * -1).ToString("######0.00") + ")"); ew.printLine("AveMX%SP = " + MXavg.ToString("#######0.00")); ew.printLine("AveMN%SP = " + (MNAvg * -1).ToString("#######0.00")); // pn list ew.printLine(); one = "MX%SP Selected PNs' List : "; for (int i = 0; i < MXselectCount; i++) { one = one + (MXselectPN[i] + 1).ToString() + " "; } ew.printLine(one); one = "MN%SP Selected PNs' List : "; for (int i = 0; i < MNselectCount; i++) { one = one + (MNselectPN[i] + 1).ToString() + " "; } ew.printLine(one); ew.printLine(); ew.printArray("MID4_3: Result:", mid4_3); ew.printLine(); ew.Save(); ew.Close(); }