ComponentOne
Web API Explorer ASP.NET Web API Explorer

MVCFlexGrid

Virtual Scrolling

This sample demonstrates how to export a virtual scrolling mvc FlexGrid to excel file.

Features

loading...

Settings


Export
Export Name :

Description

This sample demonstrates how to export a virtual scrolling mvc FlexGrid to excel file.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
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 _flexGridVirtualScrollingModel = new GridExportImportOptions
        {
            NeedExport = true,
            NeedImport = false,
            IncludeColumnHeaders = true
        };
  
        public IActionResult VirtualScrolling()
        {
            ViewBag.Options = _flexGridVirtualScrollingModel;
            return View();
        }
  
        public IActionResult VirtualScrolling_Bind([C1JsonRequest] CollectionViewRequest<Sale> requestData)
        {
            return this.C1Json(CollectionViewHelper.Read(requestData, Sale.GetData(100000)));
        }
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
@{
    GridExportImportOptions optionsModel = ViewBag.Options;
    ViewBag.DemoSettings = true;
}
  
<c1-flex-grid id="@optionsModel.ControlId" is-read-only="true" class="grid">
    <c1-items-source initial-items-count="100" read-action-url="@Url.Action("VirtualScrolling_Bind")"></c1-items-source>
</c1-flex-grid>
  
@section Settings{
    @Html.Partial("_FlexGridOptions", optionsModel)
}
  
@section Description{
    <p>@Html.Raw(MVCFlexGrid.VirtualScrolling_Text0)</p>
}