select grid data except the column with edit button

[Lienys]

How can I do:

var allData = $("#grid").data("kendoGrid").dataSource.data();

allData = allData.column(-1); ==> this delete the last column..

[Lienys]

How can I get the grid data except the Command column that I add?

[Dimiter Madjarov]

Hello Lienys,


I am not sure that I understand the current question. The data() method of the dataSource returns all of the data items in the Grid with all their model properties, not just the ones that are bound to any column. You could also use the view() method of the dataSource to get them with the according paging, filtering, grouping etc. applied.

Please let me know if this is the required behavior or I could assist you further.

Regards,
Dimiter Madjarov
Telerik

 

 

[Lienys]

My problem is:

I am exporting the grid data to excel, and when I create an edit/destroy page I bound an edit/destroy column, which is perfect for functionality, but when I want to export, the edit/destroy column appears in my data() and when I try to export to Excel I'm not expecting this extra column without header.

what I need is the grid data according to my model and not with the extra column.

how can I get that information?

thanks in advance

[Dimiter Madjarov]

Hello Lienys,


As stated in my previous post, the data() method of the dataSource returns the items according to the model. The dataSource is not aware of the commands, being used in the Grid.

If the problem is still persisting, could you please share a sample project, demonstrating the current scenario and the exact problem, so I could assist further if needed?


Regards,
Dimiter Madjarov
Telerik

 

 

[Lienys]

I will give you some photos and code, you will see the difference between the two grids are the command-column.

my.js
        // export to excel
        $("#toExcel").click(function ()
        {
            var title = getCurrentViewName();

            var dg = $("#grid").data("kendoGrid");

            var gridData = getFilteredData(); 

            var data = {
                grid: JSON.stringify(gridData),
                columns: JSON.stringify(dg.columns),
                title: title
            };

            //Create the spreadsheet.
            $.ajax({
                type: "POST",
                url: "/ClientFunction/ExportToExcel",
                contentType: "application/json; charset=utf-8",
                dataType: "json",
                data: JSON.stringify(data)
            })
            .done(function (e) {
                // Download the spreadsheet.
                window.location = kendo.format("{0}?title={1}",
                    "/ClientFunction/GetExcelFile",
                    title);
            });

        });

function getFilteredData()
{
    var ds = $("#grid").data("kendoGrid").dataSource;

    var filters = ds.filter();

    var allData = ds.data();

    var query = new kendo.data.Query(allData);

    var gridData = query.filter(filters).data;

    return gridData;
}

I'm using the excel.cs from:
http://blogs.telerik.com/kendoui/posts/13-03-12/exporting_the_kendo_ui_grid_data_to_excel
which I downloaded from:
https://github.com/telerik/kendo-examples-asp-net-mvc/tree/master/grid-export-to-excel

[Dimiter Madjarov]

Hi Lienys,


This behavior is expected in the current case. The columns object of the Grid is sent to the controller, where the title property of each column is used to generate the title of each column in the spreadsheet. As the exception explicitly states, the command column does not have a title. As a solution you could splice only the columns that are required for the spreadsheet generation.
E.g.

//assuming that the last column is not needed
 JSON.stringify(dg.columns.splice(0, dg.columns.length - 1))

Regards,
Dimiter Madjarov
Telerik

 

 

[Lienys]

Thank you so much! it work!!!