ComponentOne
Web API Explorer ASP.NET Web API Explorer
Wijmo5FlexGrid

Wijmo5FlexGrid

Overview

This sample demonstrates how to export and import a wijmo5 flexgrid to excel file.

Features

Overview
Paging
Grouping
Hierarchical Data
Filtering
Frozen Cells
Conditional Styling
Id
Date
Time
Country
Downloads
Sales
Expenses
Checked
0
Nov/20/2015
7:31 AM
Japan
476
771.69
573.15
1
Sep/13/2015
5:54 PM
Germany
964
6,478.22
4,851.38
2
May/13/2015
6:42 PM
US
162
8,592.49
1,506.01
3
Feb/20/2015
1:06 PM
Greece
793
580.77
2,283.65
4
Mar/18/2015
12:25 AM
US
47
6,386.36
3,092.64
5
Apr/11/2015
10:25 AM
Germany
591
2,423.52
26.05
6
Jun/13/2015
8:21 PM
UK
594
9,821.27
4,030.36
7
Feb/09/2015
5:57 PM
US
947
9,003.97
1,938.00
8
Jun/04/2015
10:49 PM
Germany
839
4,042.33
509.33
9
Oct/10/2015
6:07 PM
Italy
101
1,373.31
2,682.76
10
Feb/17/2015
9:23 AM
Japan
861
3,498.27
1,219.76
11
Jul/21/2015
6:34 AM
Greece
217
3,186.79
3,729.91
12
Feb/23/2015
11:57 PM
Germany
887
1,811.73
3,257.52
13
May/19/2015
12:41 PM
US
285
5,535.04
4,694.37
14
Nov/22/2015
4:45 PM
Japan
167
3,730.78
2,759.90

Settings


Export & Import
Export Name :           

Description

This sample demonstrates how to export and import a wijmo5 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
using Microsoft.AspNetCore.Mvc;
using WebApiExplorer.Models;
  
namespace WebApiExplorer.Controllers
{
    public partial class Wijmo5FlexGridController : Controller
    {
        private readonly GridExportImportOptions _flexGridModel = new GridExportImportOptions
        {
            NeedExport = true,
            NeedImport = true,
            IncludeColumnHeaders = true
        };
  
        public IActionResult Index()
        {
            ViewBag.Options = _flexGridModel;
            return View();
        }
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
@{
    GridExportImportOptions optionsModel = ViewBag.Options;
    ViewBag.DemoSettings = true;
}
  
<div id="@(optionsModel.ControlId)" style="height:300px"></div>
@section Settings{
    @Html.Partial("_FlexGridOptions", optionsModel)
}
<script>
    var grid = new wijmo.grid.FlexGrid('#@(optionsModel.ControlId)');
    initializeFlexGrid(grid);
</script>
@section Description{
    @Html.Raw(Wijmo5FlexGrid.Index_Text0)
}