private void UpdateSingleReport(IExcelWorkbook workBook, TransactionReport report) { ExcelSheetData sheetData = new ExcelSheetData(); List <string> headers = Transaction.GetTransactionHeaders().ToList(); ColorConverter converter = new ColorConverter(); int col_LAST = COL_FIRST + headers.Count - 1; Transaction template = new Transaction(); int col_CATEGORY = COL_FIRST + headers.IndexOf(ReflectionTools.GetName(() => template.Category)); int col_SUB_CATEGORY = COL_FIRST + headers.IndexOf(ReflectionTools.GetName(() => template.SubCategory)); int iTransactionRow = 2; foreach (var transaction in report.Transactions) { ExcelCellData categoryData = new ExcelCellData(iTransactionRow, col_CATEGORY); categoryData.Value = transaction.Category; sheetData.Cells.Add(categoryData); ExcelCellData subCategoryData = new ExcelCellData(iTransactionRow, col_SUB_CATEGORY); subCategoryData.Value = transaction.SubCategory; sheetData.Cells.Add(subCategoryData); Color color = Color.White; if (transaction.Color.IsNotNull()) { color = (Color)converter.ConvertFromString(transaction.Color); } ExcelRangeInfo iRange = new ExcelRangeInfo(iTransactionRow, COL_FIRST, iTransactionRow, col_LAST); ExcelFormatData colorFormat = new ExcelFormatData(iRange); colorFormat.Background = color; sheetData.Formats.Add(colorFormat); iTransactionRow++; } IExcelSheet sheet = workBook.GetSheet(report.Name); sheet.InsertSheetData(sheetData); }
public IExcelSheet GetSheet(string sheetName) { IExcelWorkbook workbook = _app.GetActiveWorkbook(); return(workbook.GetSheet(sheetName)); }