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
Aug/20/2015
8:17 AM
Germany
29
3,455.15
3,837.82
1
Aug/23/2015
4:30 AM
Germany
672
8,078.80
3,123.38
2
Jul/09/2015
12:45 PM
Greece
415
250.13
759.19
3
May/08/2015
3:11 AM
Italy
209
1,196.91
705.53
4
Feb/24/2015
5:59 PM
Italy
694
2,118.22
784.90
5
Aug/05/2015
2:09 PM
Japan
736
2,514.76
1,040.82
6
Jan/02/2015
11:21 AM
Greece
501
1,927.75
2,613.08
7
Mar/07/2015
10:01 PM
Italy
508
5,377.39
2,247.70
8
Nov/12/2015
12:39 AM
Greece
300
960.42
4,856.73
9
Feb/04/2015
7:20 AM
UK
992
4,552.39
3,741.92
10
Aug/11/2015
2:05 AM
Italy
662
8,633.51
3,384.62
11
Jan/01/2015
12:21 PM
Italy
673
1,096.02
3,890.73
12
Jul/06/2015
8:52 AM
Germany
145
4,555.15
3,588.58
13
Apr/01/2015
9:51 AM
Germany
233
1,100.84
3,575.74
14
Oct/19/2015
11:11 PM
Japan
239
7,005.47
4,697.52

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
22
23
24
25
26
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using WebApiExplorer.Models;
 
namespace WebApiExplorer.Controllers
{
    public partial class Wijmo5FlexGridController : Controller
    {
        private readonly GridExportImportOptions _flexGridFrozenCellsModel = new GridExportImportOptions
        {
            NeedExport = true,
            NeedImport = false,
            IncludeColumnHeaders = true
        };
 
        public ActionResult 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
@using WebApiExplorer.Models
@{
    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>@(Resources.Wijmo5FlexGrid.FrozenCells_FrozenColumns)</b> ' + fcMenu.text;
    }
 
    function updateFRMenuHeader() {
        frMenu.header = '<b>@(Resources.Wijmo5FlexGrid.FrozenCells_FrozenRows)</b> ' + frMenu.text;
    }
 
</script>
@section Description{
    @Html.Raw(Resources.Wijmo5FlexGrid.FrozenCells_Text0)
}