protected override string ConvertRowIndexToNameOverride(HeaderNameRenderingConverterContext context, int rowIndex) { int firstVisibleColumnIndex = context.VisibleRange.FromIndex.ColumnIndex; int firstTableColumnIndex = this.TableCellRange.FromIndex.ColumnIndex; int lastTableColumnIndex = this.TableCellRange.ToIndex.ColumnIndex; string result = base.ConvertRowIndexToNameOverride(context, rowIndex); if ((firstVisibleColumnIndex > firstTableColumnIndex && firstVisibleColumnIndex <= lastTableColumnIndex) && this.TableCellRange.Contains(rowIndex, firstVisibleColumnIndex)) { CellSelection selection = context.Worksheet.Cells[rowIndex, firstTableColumnIndex]; ICellValue cellValue = selection.GetValue().Value; CellValueFormat cellFormat = selection.GetFormat().Value; result = cellValue.GetResultValueAsString(cellFormat); } return result; }
protected override string ConvertRowIndexToNameOverride(HeaderNameRenderingConverterContext context, int rowIndex) { int firstVisibleColumnIndex = context.VisibleRange.FromIndex.ColumnIndex; int firstTableColumnIndex = this.TableCellRange.FromIndex.ColumnIndex; int lastTableColumnIndex = this.TableCellRange.ToIndex.ColumnIndex; string result = base.ConvertRowIndexToNameOverride(context, rowIndex); if ((firstVisibleColumnIndex > firstTableColumnIndex && firstVisibleColumnIndex <= lastTableColumnIndex) && this.TableCellRange.Contains(rowIndex, firstVisibleColumnIndex)) { CellSelection selection = context.Worksheet.Cells[rowIndex, firstTableColumnIndex]; ICellValue cellValue = selection.GetValue().Value; CellValueFormat cellFormat = selection.GetFormat().Value; result = cellValue.GetResultValueAsString(cellFormat); } return(result); }
protected override string ConvertColumnIndexToNameOverride(HeaderNameRenderingConverterContext context, int columnIndex) { return columnIndex.ToString(); }
protected override string ConvertColumnIndexToNameOverride(HeaderNameRenderingConverterContext context, int columnIndex) { return(columnIndex.ToString()); }