从Kendo Grid数据源导出所有数据 [英] Exporting all data from Kendo Grid datasource

问题描述

我遵循了有关导出Kendo网格数据的教程: http://www.kendoui.c​​om/blogs/teamblog/posts/13-03-12/exporting_the_kendo_ui_grid_data_to_excel.aspx

I followed that tutorial about exporting Kendo Grid Data : http://www.kendoui.com/blogs/teamblog/posts/13-03-12/exporting_the_kendo_ui_grid_data_to_excel.aspx

现在我正在尝试导出所有数据(不仅是显示的页面)...我该怎么做?

Now I´m trying to export all data (not only the showed page) ... How can I do that?

我尝试在获取数据之前更改pagezise:

I tried change the pagezise before get the data:

grid.dataSource.pageSize(grid.dataSource.total());

但是，我的实际网格刷新为新的pageSize.这是查询剑道数据源而不刷新网格的一种方法吗?

But with that my actual grid refresh with new pageSize. Is that a way to query kendo datasource without refresh the grid?

谢谢

推荐答案

更好的解决方案是从真实数据而不是从dataSource生成Excel文件.

A better solution is to generate an Excel file from the real data, not from the dataSource.

1] 在html页面中，添加

1] In the html page, add

$('#export').click(function () {
    var title = "EmployeeData";
    var id = guid();
    var filter = $("#grid").data("kendoGrid").dataSource._filter;

    var data = {
        filter: filter,
        title: title,
        guid: id
    };

    $.ajax({
        url: '/Employee/Export',
        type: "POST",
        dataType: 'json',
        data: JSON.stringify(data),
        contentType: "application/json; charset=utf-8",
        success: function (result) {
            window.location = kendo.format("{0}?title={1}&guid={2}", '/Employee/GetGeneratedExcel', title, id);
        }
    });
});

2] 将方法导出"添加到控制器:

2] Add a method "Export" to the controller:

[HttpPost]
public JsonResult Export(KendoGridFilter filter, string guid)
{
    var gridRequest = new KendoGridRequest();
    if (filter != null)
    {
        gridRequest.FilterObjectWrapper = filter.Filters != null ? filter.ToFilterObjectWrapper() : null;
        gridRequest.Logic = filter.Logic;
    }

    var query = GetQueryable().AsNoTracking();
    var results = query.FilterBy<Employee, EmployeeVM>(gridRequest);

    using (var stream = new MemoryStream())
    {
        using (var excel = new ExcelPackage(stream))
        {
            excel.Workbook.Worksheets.Add("Employees");
            var ws = excel.Workbook.Worksheets[1];
            ws.Cells.LoadFromCollection(results);
            ws.Cells.AutoFitColumns();

            excel.Save();
            Session[guid] = stream.ToArray();
            return Json(new { success = true });
        }
    }
}

3] 还将方法"GetGeneratedExcel"添加到控制器:

3] Also add the method "GetGeneratedExcel" to the controller:

[HttpGet]
public FileResult GetGeneratedExcel(string title, string guid)
{
    // Is there a spreadsheet stored in session?
    if (Session[guid] == null)
    {
        throw new Exception(string.Format("{0} not found", title));
    }

    // Get the spreadsheet from session.
    var file = Session[guid] as byte[];
    string filename = string.Format("{0}.xlsx", title);

    // Remove the spreadsheet from session.
    Session.Remove(title);

    // Return the spreadsheet.
    Response.Buffer = true;
    Response.AddHeader("Content-Disposition", string.Format("attachment; filename={0}", filename));
    return File(file, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", filename);
}

也可以在 github 上看到该项目.

Also see this project on github.

请参见此实时示例项目，您可以在其中将员工导出到Excel. (尽管这会返回过滤后的数据，但是您可以修改代码以忽略kendo网格过滤器，并始终返回所有数据.

See this live example project where you can export the Employees to Excel. (Although this returns filtered data, but you can modify the code to ignore the kendo grid filter and always return all data.

这篇关于从Kendo Grid数据源导出所有数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！