C# (CSharp) GridCellExcelExportingEventArgs Examples

Example #1

File: ExcelExportCommand.cs Project: syncfusion/wpf-demos

 private static void CustomizeCellExportingHandler(object sender, GridCellExcelExportingEventArgs e)
 {
     if (e.ColumnName == "Discount" || e.ColumnName == "ProductName")
     {
         e.Range.CellStyle.ColorIndex = ExcelKnownColors.Violet;
     }
 }

Example #2

File: Exporting.xaml.cs Project: WangHengXu/uwp-demos

 public void CustomizedCellExportingHandler(object sender, GridCellExcelExportingEventArgs args)
 {
     if (args.ColumnName == "Designation" || args.ColumnName == "Title")
     {
         args.Range.CellStyle.ColorIndex = ExcelKnownColors.Violet;
     }
 }

Example #3

File: ExportSelectedCommand.cs Project: dmonjeau/wpf-demos

 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;
     }
 }

Example #4

 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";
     }
 }

Example #5

        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;
            }
        }

Example #6

File: wExportFormat.xaml.cs Project: shresthamir/WMS

        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;
            //    }
            //}
        }

Example #7

        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;
                }
            }
        }

Example #8

File: ExportCommand.cs Project: asiertarancon/atg.Concesionario

        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;
                }
            }
        }

Example #9

File: Exporting.xaml.cs Project: WangHengXu/uwp-demos

 public void CellExportingHandler(object sender, GridCellExcelExportingEventArgs args)
 {
     args.Range.CellStyle.Font.FontName = "Segoe UI";
 }

Example #10

File: ExcelExportingPage.xaml.cs Project: ronlemire2/UWP-Apps

 public void CustomizedCellExportingHandler(object sender, GridCellExcelExportingEventArgs args) {
     if (args.ColumnName == "Designation") {
         args.Range.CellStyle.ColorIndex = ExcelKnownColors.Violet;
     }
 }

Example #11

File: ExcelExportingPage.xaml.cs Project: ronlemire2/UWP-Apps

 public void CellExportingHandler(object sender, GridCellExcelExportingEventArgs args) {
     args.Range.CellStyle.Font.FontName = "Segoe UI";
 }

Example #12

File: Commands.cs Project: xunmengnanhaier/wpf-demos

 private static void CellExportingHandler(object sender, GridCellExcelExportingEventArgs e)
 {
     e.Range.CellStyle.Font.Size     = 12;
     e.Range.CellStyle.Font.FontName = "Segoe UI";
 }