Copy paste excel cells into grid OR copy cells from email directly to grid.

Question

Hi Team,Do we have any feature which can support direct copy-paste from excel or emails ? If yes could you please provide us link to sample and documentation ?

Shalini Maragathavel · Accepted Answer

Hi Komal, 
Thanks for contacting Syncfusion support. 
By default in EJ2 Grid we have implemented copy and paste feature based on Microsoft Excel’s copy and paste feature . 

When coping one cell value from another table and paste it to multiple cells that we selected in excel only copied value pasted in first selected cell. Likewise we have implemented in Grid like when coping one cell value from excel and paste it to multiple cells that we selected in Grid, copied value pasted in first selected cell only.  

Please refer below video demonstration.  
 
Video demonstration: https://www.syncfusion.com/downloads/support/directtrac/288292/ze/CopyPaste174785770  
Please refer the below sample for your reference .  
 
Sample: https://stackblitz.com/edit/angular-efxpd4-5tyvkn?file=app.component.html 
              https://www.syncfusion.com/downloads/support/directtrac/general/ze/exceldocument1582706079.zipPlease get back to us if you need further assistance  
Regards, 
Shalini M.

Komal Pandya · Answer

Hi Team,I am able to copy and paste from excel cells now, but those cells are showing in green, looks like still in not saved mode. So upon performing any other actions, these cells are rolled back to the original value. Could you please help me how can we save those records without showing confirm dialog box ?Thanks.

Rajapandiyan Settu · Answer

Hi Komal, 
 
Thanks for your update. 
 
Query: Could you please help me how can we save those records without showing confirm dialog box ? 
 
By default in Batch mode, the edited records are displayed with green background and those data are not saved in the Grid. You can save those batch edited data by using Update button in the Toolbar or executing grid.endEdit() method.  
 
The confirmation dialog will be shown before saving the edited data in the Grid. You can avoid this by setting showConfirmDialog as false in the Grid’s editSettings. 
 
endEdit: https://ej2.syncfusion.com/angular/documentation/api/grid#endedit 
 
showConfirmDialog: https://ej2.syncfusion.com/angular/documentation/api/grid/editSettings/#showconfirmdialog 
 




this.editSettings = { 
      allowEditing: true, 
      allowAdding: true, 
      allowDeleting: true, 
      showConfirmDialog: false, 
      mode: "Batch" 
    }; 
 
Sample: https://stackblitz.com/edit/angular-efxpd4-wpbxnw?file=app.component.ts  
 
Please get back to us if you need further assistance with this. 
 
Regards, 
Rajapandiyan S