protected void generateDateLine(List <string> tradingDays_, ISheet tab_, HSSFWorkbook wb_) { IRow row = tab_.CreateRow(currentLine++); ICell[] cells = new ICell[5]; for (int i = 0; i < 5; i++) { cells[i] = row.CreateCell(i, CellType.String); } HSSFCellStyle style = CellStyle.headingStyle(wb_); cells[0].SetCellValue("TradingDay : "); cells[0].CellStyle = style; cells[1].SetCellValue("From "); cells[1].CellStyle = style; cells[2].SetCellValue(tradingDays_[0]); cells[2].CellStyle = style; cells[3].SetCellValue(" To "); cells[3].CellStyle = style; cells[4].SetCellValue(tradingDays_[tradingDays_.Count - 1]); cells[4].CellStyle = style; }
private void addStatistics(List <ClientTradeSummary> tradeStatistics_, ISheet tab_, HSSFWorkbook wb_) { HSSFCellStyle leftColStyle = CellStyle.headingStyle(wb_); HSSFCellStyle contentStyle = CellStyle.contentStyle(wb_); foreach (ClientTradeSummary summary in tradeStatistics_) { IRow row = tab_.CreateRow(currentLine++); ICell[] cells = new ICell[columeNb]; cells[0] = row.CreateCell(0, CellType.String); cells[0].SetCellValue(summary.getAccountId()); cells[0].CellStyle = leftColStyle; cells[1] = row.CreateCell(1, CellType.String); cells[1].SetCellValue(summary.getAbbrName()); cells[1].CellStyle = leftColStyle; cells[2] = row.CreateCell(2, CellType.Numeric); cells[2].SetCellValue((double)MathUtil.round(summary.getTotalTurnover(), 2)); cells[2].CellStyle = leftColStyle; cells[3] = row.CreateCell(3, CellType.Numeric); cells[3].SetCellValue((double)MathUtil.round(summary.getFillRate(), 4)); cells[3].CellStyle = leftColStyle; cells[4] = row.CreateCell(4, CellType.Numeric); cells[4].SetCellValue((double)MathUtil.round(summary.getCancelRate(), 4)); cells[4].CellStyle = leftColStyle; int firstPosition = FIRST_NUMERIC_COLUME; int offset = 0; int algoNb = 0; foreach (OrderAlgo algo in sortedAlgos) { StrategyStatistics algoStrategy = summary.getByAlgo(algo); offset = columeEachAlgo * algoNb + firstPosition; cells[offset + 0] = row.CreateCell(offset + 0, CellType.Numeric); cells[offset + 0].SetCellValue((double)MathUtil.round(algoStrategy.getOrderCount(), 2)); cells[offset + 0].CellStyle = contentStyle; cells[offset + 1] = row.CreateCell(offset + 1, CellType.Numeric); cells[offset + 1].SetCellValue((double)MathUtil.round(algoStrategy.getSliceCount(), 2)); cells[offset + 1].CellStyle = contentStyle; cells[offset + 2] = row.CreateCell(offset + 2, CellType.Numeric); cells[offset + 2].SetCellValue((double)MathUtil.round(algoStrategy.getSlipage(), 2)); cells[offset + 2].CellStyle = contentStyle; cells[offset + 3] = row.CreateCell(offset + 3, CellType.Numeric); cells[offset + 3].SetCellValue((double)MathUtil.round(algoStrategy.getTurnover(), 2)); cells[offset + 3].CellStyle = contentStyle; algoNb++; } } }
protected void createSheetHeader(ISheet tb_, HSSFWorkbook wb_) { IRow row0 = tb_.CreateRow(currentLine++); int columeNb = columeName.Length; HSSFCellStyle style = CellStyle.headingStyle(wb_); for (int i = 0; i < columeNb; i++) { ICell cell = row0.CreateCell(i); cell.CellStyle = style; cell.SetCellValue(columeName[i]); } row0.Height = 1000; }
private void addColumeNameLine(ISheet tab_, HSSFWorkbook wb_) { Array algos = Enum.GetValues(typeof(OrderAlgo)); IRow row = tab_.CreateRow(currentLine++); ICell[] cells = new ICell[columeNb]; HSSFCellStyle style = CellStyle.headingStyle(wb_); cells[0] = row.CreateCell(0, CellType.String); cells[0].SetCellValue(ACCOUNT_COLUME); cells[0].CellStyle = style; cells[1] = row.CreateCell(1, CellType.String); cells[1].SetCellValue(NAME_COLUME); cells[1].CellStyle = style; cells[2] = row.CreateCell(2, CellType.String); cells[2].SetCellValue(TURNOVER_COLUME); cells[2].CellStyle = style; cells[3] = row.CreateCell(3, CellType.String); cells[3].SetCellValue(FILLRATE_COLUME); cells[3].CellStyle = style; cells[4] = row.CreateCell(4, CellType.String); cells[4].SetCellValue(CANCEL_COLUME); cells[4].CellStyle = style; int index = FIRST_NUMERIC_COLUME; for (int i = 0; i < algos.Length; i++) { for (int j = 0; j < ALGO_RESULT_COLUMES.Length; j++) { cells[index] = row.CreateCell(index, CellType.String); cells[index].SetCellValue(ALGO_RESULT_COLUMES[j]); cells[index].CellStyle = style; index++; } } }
private void addStrategyLine(ISheet tab_, HSSFWorkbook wb_) { IRow row = tab_.CreateRow(currentLine++); ICell[] cells = new ICell[columeNb]; int firstNonBlankCell = 0; HSSFCellStyle style = CellStyle.headingStyle(wb_); int algoIndex = 0; for (int i = FIRST_NUMERIC_COLUME; i < columeNb; i++) { cells[i] = row.CreateCell(i, CellType.String); if ((i - FIRST_NUMERIC_COLUME) % columeEachAlgo == 0) { cells[i].SetCellValue(sortedAlgos[algoIndex].ToString()); cells[i].CellStyle = style; algoIndex++; if (firstNonBlankCell == 0) { firstNonBlankCell = i - ALGO_RESULT_COLUMES.Length / 2; } } else { cells[i].SetCellValue(""); cells[i].CellStyle = style; } } for (int i = 0; i <= 4; i++) { cells[i] = row.CreateCell(i, CellType.String); cells[i].CellStyle = style; cells[i].SetCellValue(""); } cells[1].SetCellValue("Total"); }