ComponentOne
Web API Explorer ASP.NET Web API Explorer
Wijmo5FlexGrid

Wijmo5FlexGrid

Frozen Cells

This sample demonstrates how to export a wijmo5 flexgrid with frozen cells to excel file.

Features

Overview
Paging
Grouping
Hierarchical Data
Filtering
Frozen Cells
Conditional Styling
Id
Date
Time
Country
Downloads
Sales
Expenses
Checked
0
Sep/02/2015
8:58 PM
US
840
8,257.36
570.79
1
Sep/24/2015
3:09 PM
Germany
338
3,593.17
549.20
2
Jan/11/2015
11:22 AM
Japan
849
7,513.68
670.50
3
Jul/06/2015
7:25 PM
Japan
250
3,846.07
4,825.94
4
Dec/21/2015
2:15 AM
Italy
674
3,566.88
4,426.50
5
Aug/23/2015
2:28 PM
US
35
4,477.65
3,083.78
6
Oct/12/2015
7:19 AM
UK
142
2,326.52
3,168.55
7
Feb/11/2015
7:37 AM
Japan
53
4,667.51
1,701.25
8
Dec/07/2015
10:18 PM
Japan
187
9,418.76
4,369.30
9
Feb/01/2015
4:46 PM
UK
603
7,168.84
404.48
10
Nov/05/2015
11:23 PM
Italy
302
2,923.33
3,556.94
11
Jan/06/2015
11:32 PM
Germany
600
6,845.23
472.05
12
Apr/06/2015
11:10 PM
Japan
66
4,484.12
2,265.40
13
Aug/01/2015
1:06 AM
Germany
506
7,139.25
4,440.91
14
Feb/17/2015
5:29 PM
Italy
909
6,456.11
4,239.37

Settings


Export
Export Name :

Description

This sample demonstrates how to export a wijmo5 flexgrid with frozen cells to excel file.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
using Microsoft.AspNetCore.Mvc;
using WebApiExplorer.Models;
  
namespace WebApiExplorer.Controllers.Wijmo5FlexGrid
{
    public partial class Wijmo5FlexGridController : Controller
    {
        private readonly GridExportImportOptions _flexGridFrozenCellsModel = new GridExportImportOptions
        {
            NeedExport = true,
            NeedImport = false,
            IncludeColumnHeaders = true
        };
  
        public IActionResult FrozenCells()
        {
            ViewBag.Options = _flexGridFrozenCellsModel;
            return View();
        }
    }
}
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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
@{
    GridExportImportOptions optionsModel = ViewBag.Options;
    ViewBag.DemoSettings = true;
}
  
<div id="@(optionsModel.ControlId)" style="height:300px"></div>
  
<select id="frozenColumnMenu">
    <option value=0>0</option>
    <option value=1 selected>1</option>
    <option value=2>2</option>
    <option value=3>3</option>
    <option value=4>4</option>
</select>
  
<select id="frozenRowMenu">
    <option value=0>0</option>
    <option value=1>1</option>
    <option value=2 selected>2</option>
    <option value=3>3</option>
    <option value=4>4</option>
</select>
  
@section Settings{
    @Html.Partial("_FlexGridOptions", optionsModel)
}
<script>
    var grid = new wijmo.grid.FlexGrid('#@(optionsModel.ControlId)'), fcMenu = new wijmo.input.Menu('#frozenColumnMenu'), frMenu = new wijmo.input.Menu('#frozenRowMenu');
    initializeFlexGrid(grid);
    grid.frozenColumns = 1;
    grid.frozenRows = 2;
  
    fcMenu.itemClicked.addHandler(function (sender) {
        grid.frozenColumns = parseInt(sender.selectedValue);
        updateFCMenuHeader();
    });
  
    frMenu.itemClicked.addHandler(function (sender) {
        grid.frozenRows = parseInt(sender.selectedValue);
        updateFRMenuHeader();
    });
  
    updateFCMenuHeader();
    updateFRMenuHeader();
  
    function updateFCMenuHeader() {
        fcMenu.header = '<b>@(Wijmo5FlexGrid.FrozenCells_FrozenColumns)</b> ' + fcMenu.text;
    }
  
    function updateFRMenuHeader() {
        frMenu.header = '<b>@(Wijmo5FlexGrid.FrozenCells_FrozenRows)</b> ' + frMenu.text;
    }
  
</script>
@section Description{
    @Html.Raw(Wijmo5FlexGrid.FrozenCells_Text0)
}