コード例 #1
0
        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]++;
        }
コード例 #2
0
        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]++;
        }