Grid Export how to trigger export programaticaly

[Ross B.]

Greetings,

How can I trigger a grid to export to pdf or excel manually. What functions are there to $('#Grid').Export() ? 

Have a good day

[Dimiter Madjarov]

Hello Ross,

You could use the built in saveAsExcel and saveAsPDF methods of the Grid API.

Regards,
Dimiter Madjarov
Telerik

 

 

[Ronald]

How can you achieve this with out it also force saving the file as using e.preventDefault() does not work in stopping the file to be saved 

[Georgi Denchev]

Hello Ronald,

You can prevent the default behavior of the Excel Export functionality through the excelExport event.

<button id="export">Export to Excel</button>
<div id="grid"></div>
<script>
$("#grid").kendoGrid({
  columns: [
    { field: "name" },
    { field: "age" }
  ],
  dataSource: [
      { name: "Jane Doe", age: 30 },
      { name: "John Doe", age: 33 }
  ],
  excelExport: function(e) {
    e.preventDefault(); // Prevent the export event.
  }
});
$("#export").click(function(e) {
    var grid = $("#grid").data("kendoGrid");
    grid.saveAsExcel();
});
</script>

Best Regards,
Georgi Denchev
Progress Telerik