MVCFlexGrid

Filtering

This sample demonstrates how to export a filtering mvc flexgrid to excel file.

Features

Sample
Source
Documentation

Start

End

Country

Product

Color

Amount

Amount2

Discount

Active

Settings

Export

Export Name :

Description

This sample demonstrates how to export a filtering mvc flexgrid to excel file.

FilteringController.cs
Filtering.cshtml

using C1.Web.Mvc; 
using C1.Web.Mvc.Serialization; 
using Microsoft.AspNetCore.Mvc; 
using WebApiExplorer.Models; 
  
namespace WebApiExplorer.Controllers 
{ 
    public partial class MVCFlexGridController : Controller 
    { 
        private readonly GridExportImportOptions _flexGridFilteringModel = new GridExportImportOptions 
        { 
            NeedExport = true, 
            NeedImport = false, 
            IncludeColumnHeaders = true
        }; 
  
        public IActionResult Filtering() 
        { 
            ViewBag.Options = _flexGridFilteringModel; 
            return View(); 
        } 
  
        public IActionResult Filtering_Bind([C1JsonRequest] CollectionViewRequest<Sale> requestData) 
        { 
            return this.C1Json(CollectionViewHelper.Read(requestData, Sale.GetData(100))); 
        } 
    } 
}

@{ 
    GridExportImportOptions optionsModel = ViewBag.Options; 
    ViewBag.DemoSettings = true; 
} 
  
<script>
    function exportControl() { 
        var exporter = new c1.mvc.ExcelExport(), 
                control = wijmo.Control.getControl("#flexgrid"); 
        exporter.requestExport(control, serverUrl + "api/export/excel", { 
            fileName: document.getElementById("exportName").value, 
            type: wijmo.ExportFileType.Xlsx, 
            onlyCurrentPage: onlyCurrentPage 
        }); 
    } 
</script>
  
<c1-flex-grid id="@optionsModel.ControlId" auto-generate-columns="false" class="grid" is-read-only="true"> 
    <c1-flex-grid-filter default-filter-type="Both"></c1-flex-grid-filter> 
    <c1-items-source read-action-url="@Url.Action("Filtering_Bind")"></c1-items-source> 
    <c1-flex-grid-column binding="ID" width="*"></c1-flex-grid-column> 
    <c1-flex-grid-column binding="Start"></c1-flex-grid-column> 
    <c1-flex-grid-column binding="End"></c1-flex-grid-column> 
    <c1-flex-grid-column binding="Country"></c1-flex-grid-column> 
    <c1-flex-grid-column binding="Product"></c1-flex-grid-column> 
    <c1-flex-grid-column binding="Color"></c1-flex-grid-column> 
    <c1-flex-grid-column binding="Amount" format="c"></c1-flex-grid-column> 
    <c1-flex-grid-column binding="Amount2" format="c"></c1-flex-grid-column> 
    <c1-flex-grid-column binding="Discount" format="p0"></c1-flex-grid-column> 
    <c1-flex-grid-column binding="Active"></c1-flex-grid-column> 
</c1-flex-grid> 
  
@section Settings{ 
    @Html.Partial("_FlexGridOptions", optionsModel) 
} 
@section Description{ 
    @Html.Raw(MVCFlexGrid.Filtering_Text0) 
}