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