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