private void addRow(Excel.Worksheet sheet, double valueMin, double valueMax, int count, double buy, double sell)
{
int row = sheetRows[sheet.Name];
if (row == 0)
{
throw new Exception("Row cant be 0");
}
sheet.Cells[row, 1] = GeneralExcelGenerator.getAsValidNumberString(valueMin);
sheet.Cells[row, 2] = GeneralExcelGenerator.getAsValidNumberString(valueMax);
sheet.Cells[row, 3] = GeneralExcelGenerator.getAsValidNumberString(count);
sheet.Cells[row, 4] = GeneralExcelGenerator.getAsValidNumberString(buy);
sheet.Cells[row, 5] = GeneralExcelGenerator.getAsValidNumberString(sell);
sheetRows[sheet.Name]++;
}
private void addRow(Excel.Worksheet sheet, double valueMin, double valueMax, int count, double maxAvg, double minAvg, double minVsMax, double actualAvg, double avgDiff)
{
int row = sheetRows[sheet.Name];
if (row == 0)
{
throw new Exception("Row cant be 0");
}
sheet.Cells[row, 1] = GeneralExcelGenerator.getAsValidNumberString(valueMin);
sheet.Cells[row, 2] = GeneralExcelGenerator.getAsValidNumberString(valueMax);
sheet.Cells[row, 3] = GeneralExcelGenerator.getAsValidNumberString(count);
sheet.Cells[row, 4] = GeneralExcelGenerator.getAsValidNumberString(maxAvg);
sheet.Cells[row, 5] = GeneralExcelGenerator.getAsValidNumberString(minAvg);
sheet.Cells[row, 6] = GeneralExcelGenerator.getAsValidNumberString(minVsMax);
sheet.Cells[row, 7] = GeneralExcelGenerator.getAsValidNumberString(actualAvg);
sheet.Cells[row, 8] = GeneralExcelGenerator.getAsValidNumberString(avgDiff);
sheetRows[sheet.Name]++;
}