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