Copy to clipboard the grid

[serge]

Our customers like to take data from the grid, and put it in editors like notepad, excel, word or others... 

 

Is there a way to copy the visible, or, all, the grid data to clipboard, as tab separated values? as in the attached picture

 

 

[serge]

Actually "solved" by using the "Export to excel" functionality, but that is not exacly that to copy the data to clipboard...

[Nikolay]

Hi Serge,

The recommended way of exporting Grid data to Excel is by using the internal Excel export functionality.

Nevertheless, you can also select all Grid data and copy it to the clipboard with some custom logic. For example:

$(document).ready(function () {
        $("#selectAll").click(function () {
          var grid = $("#grid").data("kendoGrid")
          grid.select(grid.tbody.find(">tr td"));
          grid.copySelection(grid);
          document.execCommand("copy");
        });

Here is a small Dojo demo I prepared demonstrating this:

• https://dojo.telerik.com/OVamOFuP

The logic for selecting and copying the data is also valid for Html Helper Grid.

Let me know if yo have any questions.

Regards,
Nikolay
Progress Telerik

[serge]

by the way, your Grid has this fonctionnality, to copy a selected range of data to clipboard (Excel ready) https://demos.telerik.com/aspnet-core/grid/copy-to-excel

[serge]

Hello, Nikolay

I tested your example, it does a mix between copying the visible data and available data.... I mean, it copies more than visible, but less than all data...

[Nikolay]

Hi Serge,

This can be achieved by enabling the Grid property AllowCopy which will allow the user could copy the selection into the clipboard and paste it into Excel or other similar programs that understand TSV/CSV formats.

• https://docs.telerik.com/aspnet-core/api/Kendo.Mvc.UI.Fluent/GridBuilder#allowcopy

Here is a working example you can test:

• http://dojo.telerik.com/OjAzODih

Regards,
Nikolay
Progress Telerik