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; } string s = "A1:HA" + (Common.POSN + 100).ToString(); mySheet.Range[s].Clear(); ew.printLine(); ew.printLine("MID4_2_Table (Count MX/MN Table) Print ------------------------------------"); string [] h = new string [] { "POSN", "MX+A%SP", "MX-A%SP", "MN+A%SP", "MN-A%SP" }; for (int i = 0; i < h.Length; i++) { ew.print(h[i]); } ew.printLine(); for (int i = 0; i < rd.Rows; i++) { ew.print((i + 1).ToString("####0")); for (int j = 0; j < 4; j++) { ew.print(Count_MxMn[i, j].ToString("####0")); } ew.printLine(); } ew.printLine(); //ew.printLine("MID4_2_Table sum ------------------------------------"); ew.print("SUM"); for (int j = 0; j < 4; j++) { ew.print(Sumval[j].ToString("####0")); } ew.printLine(); //ew.printLine("MID4_2_Table AVERAGE ------------------------------------"); ew.print("Average"); for (int j = 0; j < 4; j++) { ew.print(Avg[j].ToString("##0.00")); } ew.printLine(); //ew.printLine("MID4_2_Table DIGITs ------------------------------------"); ew.print("DIGITs"); for (int j = 0; j < 4; j++) { ew.print(digit[j].ToString("##0")); } ew.printLine(); 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.printLine("MID3_3_Table SPC ------------------------------------"); ew.print(" PN "); for (int j = 0; j < mid3_3_table.Cols; j++) { ew.print(((j + 1) * Common.GpspInterval).ToString("##0")); } ew.printLine(); ew.print("SPC"); for (int j = 0; j < mid3_3_table.Cols; j++) { ew.print(mid3_3_table.spc[j].ToString("##0")); } ew.printLine(); ew.printLine(); ew.printLine("MID3_3_Table spcIndex : " + mid3_3_table.spcindex.ToString() + ", max PN : " + ((mid3_3_table.spcindex + 1) * Common.GpspInterval).ToString()); ew.printLine("MID3_3_Table spcmax value : " + mid3_3_table.spcmax.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: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(); }