Skip to content

Instantly share code, notes, and snippets.

@moshiurse
Created March 29, 2020 09:21
Show Gist options
  • Save moshiurse/a35d5af6c75507ed2c46a2e9b78bef03 to your computer and use it in GitHub Desktop.
Save moshiurse/a35d5af6c75507ed2c46a2e9b78bef03 to your computer and use it in GitHub Desktop.
Excel export With Kendo Grid in angularjs
$scope.loadGridData = function(url) {
$scope.mainGridOptions = {
dataSource: {
transport: {
read: {
url: url,
dataType: "json"
}
},
pageSize: __grid_pagesize,
},
serverPaging: false,
serverSorting: false,
serverFiltering: false,
sortable: true,
selectable: true,
pageable: {
refresh: true,
pageSizes: __grid_pagesize_arr,
buttonCount: 3,
messages: {
itemsPerPage: $scope.multi_lang.grid.per_page,
display: " {0} - {1} " + $scope.multi_lang.grid.out_of + " {2} " + $scope.multi_lang.grid.records,
empty: $scope.multi_lang.grid.empty_msg,
allPages: $scope.multi_lang.grid.all_pages
}
},
excelExport: function(e) {
var sheet = e.workbook.sheets[0];
for (var rowIndex = 0; rowIndex < sheet.rows.length; rowIndex++) {
var row = sheet.rows[rowIndex];
for (var cellIndex = 0; cellIndex < row.cells.length; cellIndex ++) {
var cell =row.cells[cellIndex];
if(cell.value && cell.value.toString().indexOf("<br>") >= 0){
var regex = /<br>/gi;
cell.value = cell.value.replace(regex, "\n");
cell.wrap = true;
}
}
}
e.workbook.fileName = "Prozessüberwachung.xlsx";
},
filterable: { mode: "row" },
dataBound: function(e) {
var grid = this;
grid.tbody.find("tr").dblclick(function(e) {
var dataItem = grid.dataItem(this);
$scope.open_details(dataItem);
});
},
columns: $scope.columns_def
};
}
$scope.exportToExcel = function(){
var grid = $("#kendo-grid").data("kendoGrid");
grid.saveAsExcel();
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment