Paste New Rows in Grid
We can paste data in last row by paste method
HTML
<script src="http://cdn.wijmo.com/5.20161.151/controls/wijmo.min.js"></script>
<link rel="stylesheet" href="http://cdn.wijmo.com/5.20161.151/styles/wijmo.min.css">
<script src="http://cdn.wijmo.com/5.20161.151/controls/wijmo.grid.min.js"></script>
<script src="http://cdn.wijmo.com/5.20161.151/interop/angular/wijmo.angular.min.js"></script>
<div ng-app="app">
<div ng-controller="appCtrl">
<!-- This is a grid -->
<wj-flex-grid items-source="data" pasted="pasted(s,e)" control="flex">
</wj-flex-grid>
</div>
</div>
JavaScript
var pastedData;// contain data to be paste
document.addEventListener('paste', function (e) {
pastedData = e.clipboardData.getData('text/plain');
console.log('pasted data: '+ pastedData);
});
// declare app module
var app = angular.module('app', ['wj']);
// app controller provides data
app.controller('appCtrl', function appCtrl($scope) {
// generate some random data
var countries = 'US,Germany,U K,Japan,Italy,Greece'.split(','), data = [];
for (var i = 0; i < 10; i++) {
data.push({
id: i,
country: countries[i % countries.length],
date: new Date(2014, i % 12, i % 28),
amount: Math.random() * 10000,
active: i % 4 == 0
});
}
// add data array to scope
$scope.data = new wijmo.collections.CollectionView(data);
$scope.pasted = function (s, e) {
console.log('Paste Event in Grid');
if (e.row == $scope.flex.rows.length - 1) {
if (pastedData.split("\n").length > 1) {
var pastedDataArray = pastedData.split("\n");
for (var i = 1; i < pastedDataArray.length ; i++) {
// Add data to collection View
var newItem=$scope.flex.collectionView.addNew();
var itemToAdd = pastedDataArray[i].split("\t");
newItem.id = itemToAdd[0];
newItem.country = itemToAdd[1];
newItem.date = itemToAdd[2];
newItem.amount = itemToAdd[3];
newItem.active = itemToAdd[4];
$scope.flex.collectionView.commitNew();
...