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