Syncfusion WPF Controls Demos

To visualize weather data in the Weather Analysis showcase demo, you must provide historical weather data in a specific JSON format. Follow these steps to prepare the data:

1. Download Historical Data:
   • Visit Visual Crossing Weather Data Services.
   • Enter a location and select a date range.
   • Under "Query options", select the desired weather information and choose "Daily" weather data.
   • Download the data.
2. Project Setup: Place the downloaded file into the Data Store folder within the project.
3. Configure City: Open program.cs and specify the city name you wish to use.
4. Generate JSON: Run the utility to generate consolidated data, which will be output to the JSON Datas folder.
5. Deploy Data: Copy the generated JSON file from the JSON Datas folder to the project's raw data directory: wpf-demos\showcase\weather analysis\DataStore\RawData.

When exporting from SfDataGrid to Excel, you can intercept the export process using event handlers to apply custom styles or format specific cell values.

Exporting Event Handlers

• ExportingEventHandler: Used to apply styles to entire rows or headers. In the provided implementation, this can be used to set BackGroundBrush, ForeGroundBrush, and FontInfo (Bold, Size, FontName).
• CellsExportingEventHandler: Used for fine-grained control over individual cells. This is ideal for:
  • Setting specific font sizes or names for a range.
  • Formatting specific columns (e.g., converting string values to numeric types for columns like UnitPrice or Quantity).

Export Cell Types

When handling these events, check the e.CellType to target specific parts of the grid:

• ExportCellType.HeaderCell: The header row.
• ExportCellType.RecordCell: The data rows.

Implementation Note

Set e.Handled = true after applying custom logic to prevent the default export behavior from overwriting your changes.

// Example of customizing cell exporting
private static void CellExportingHandler(object sender, GridCellExcelExportingEventArgs e)
{
    // Apply font styles to the range
    e.Range.CellStyle.Font.Size = 12;
    e.Range.CellStyle.Font.FontName = "Segoe UI";

    // Target specific columns for numeric formatting
    if (e.ColumnName == "UnitPrice" || e.ColumnName == "Quantity")
    {
        if (e.CellType == ExportCellType.HeaderCell) return;

        if (double.TryParse(e.CellValue.ToString(), out double value))
        {
            e.Range.Number = value;
        }
        e.Handled = true;
    }
}

You can intercept the export process using specific event handlers to apply custom branding or formatting to the PDF document.

GridPdfExportingEventArgs

Use the ExportingEventHandler to apply background colors to different cell types:

• ExportCellType.HeaderCell: Typically used for column headers.
• ExportCellType.GroupCaptionCell: Used for group headers.
• ExportCellType.GroupSummaryCell: Used for summaries within a group.
• ExportCellType.TableSummaryCell: Used for the final table summary.

GridCellPdfExportingEventArgs

Use the CellsExportingEventHandler to apply specific styles to individual cells based on column names or cell types (e.g., ExportCellType.RecordCell).

PdfHeaderFooterEventArgs

Use the PageHeaderFooterEventHandler to define PdfPageTemplateElement objects for the Top (header) and Bottom (footer) of each page. This is commonly used to draw images or text at the top and bottom of the document.

// Example: Styling headers in the ExportingEventHandler
static void GridPdfExportingEventhandler(object sender, GridPdfExportingEventArgs e)
{
    if (e.CellType == ExportCellType.HeaderCell)
    {
        e.CellStyle.BackgroundBrush = PdfBrushes.LightSteelBlue;
    }
    // ... other cell types
}