private static void CustomizeCellExportingHandler(object sender, GridCellExcelExportingEventArgs e) { if (e.ColumnName == "Discount" || e.ColumnName == "ProductName") { e.Range.CellStyle.ColorIndex = ExcelKnownColors.Violet; } }
public void CustomizedCellExportingHandler(object sender, GridCellExcelExportingEventArgs args) { if (args.ColumnName == "Designation" || args.ColumnName == "Title") { args.Range.CellStyle.ColorIndex = ExcelKnownColors.Violet; } }
private static void CellExportingHandler(object sender, GridCellExcelExportingEventArgs e) { e.Range.CellStyle.Font.Size = 14; e.Range.CellStyle.Font.FontName = "Segoe UI"; if (e.CellType == ExportCellType.RecordCell) { e.Range.CellStyle.Font.Color = ExcelKnownColors.Pink; } }
private static void CellExportingHandler(object sender, GridCellExcelExportingEventArgs e) { if (e.ColumnName == "cod_ref") { e.Range.CellStyle.NumberFormat = "0"; //e.Range.CellStyle.Font.Color = ExcelKnownColors.Blue; //e.Range.CellStyle.Font.FontName = "Segoe UI"; } }
private static void CellExportingHandler(object sender, GridCellExcelExportingEventArgs e) { e.Range.CellStyle.Font.Size = 12; e.Range.CellStyle.Font.FontName = "Segoe UI"; if (e.ColumnName == "UnitPrice" || e.ColumnName == "Quantity") { double value = 0; if (double.TryParse(e.CellValue.ToString(), out value)) { e.Range.Number = value; } e.Handled = true; } }
private static void CellExportingHandler(object sender, GridCellExcelExportingEventArgs e) { //e.Range.CellStyle.Font.Size = 12; //e.Range.CellStyle.Font.FontName = "Segoe UI"; //if (e.ColumnName == "UnitPrice" || e.ColumnName == "UnitsInStock") //{ // double value = 0; // if (double.TryParse(e.CellValue.ToString(), out value)) // { // e.Range.Number = value; // e.Handled = true; // } //} }
public void cellsExportingHandler(object sender, GridCellExcelExportingEventArgs args) { if (args.CellType == ExportCellType.RecordCell) { args.Range.CellStyle.Font.FontName = "Segoe UI"; if (args.ColumnName == "DateTime") { args.Range.Text = Convert.ToDateTime(args.CellValue).ToString(@"MMM dd yyyy"); args.Range.HorizontalAlignment = ExcelHAlign.HAlignRight; args.Handled = true; } else if (args.ColumnName == "Amount") { args.Range.Number = (double)args.CellValue; args.Range.CellStyle.NumberFormatIndex = 5; args.Handled = true; } } }
public void CellExportingHandler(object sender, GridCellExcelExportingEventArgs args) { args.Range.CellStyle.Font.FontName = "Segoe UI"; }
public void CustomizedCellExportingHandler(object sender, GridCellExcelExportingEventArgs args) { if (args.ColumnName == "Designation") { args.Range.CellStyle.ColorIndex = ExcelKnownColors.Violet; } }
private static void CellExportingHandler(object sender, GridCellExcelExportingEventArgs e) { e.Range.CellStyle.Font.Size = 12; e.Range.CellStyle.Font.FontName = "Segoe UI"; }