Export to Excel/PDF

Export to Excel

FlexGrid can export data to CSV, PDF, XLSX/XLSM, and HTML using the C1.WinUI.Grid.Excel assembly. The export functionality is exposed through the asynchronous SaveAsync method.

Supported File Formats

These are the save file formats that this extension supports.

Options

Row and Column Options

This specifies options available for customizing the excel output when grid is exported. These are the row(s) and column(s) export options that this extension supports.

Header Options

This specifies constants that defines which header cells are displayed in the exported file. These are the row(s) and column(s) grid header visibility options that this extension supports.

Rendering Options

This specifies additional options available for rendering merged ranges, formatted values, and images.

Sample Usage

The following example shows how to use the SaveAsync method to export FlexGrid to Excel files. In this example, we used the Name property to name the FlexGrid control as "grid".

using C1.DataCollection;
using C1.WinUI.Core;
using C1.WinUI.Grid;
using GrapeCity.Documents.Excel;
private async void OnExportClick(object sender, RoutedEventArgs e)
  {
    var savePicker = new FileSavePicker();
    savePicker.DefaultFileExtension = ".xlsx";
    try
      {
        file = await savePicker.PickSaveFileAsync();
        await grid.SaveAsync(
          file.Path,
          "FlexGrid Sheet", //Sheet Name
          SaveFileFormat.Xlsm, //GrapeCity.Documents.Excel.SaveFileFormat: Represents the format in which the workbook is saved
          new GridRowColRanges("1-5", rows = GridRowColRangesOptions.VisibleOnly),
          new GridRowColRanges("1-5", columns = GridRowColRangesOptions.VisibleOnly),
          headers: GridHeadersVisibility.All,
          merged: checkMerged.IsChecked ?? false,
          formatted: checkFormatted.IsChecked ?? false,
          renderImages: checkRenderImages.IsChecked ?? false);
      }
      catch { }
  }