Copy From Excel On Sheet2 not working

[Punit]

Dear Team,
We try to copy from sheet 2 but we always get the value of sheet 1. We write the below code to copy from 1 grid and paste it to another grid. Is there any alternate way to achieve this? Also if we copy a value from sheet 2 and copy this value to the clipboard then it works fine in local but not in production.


var $grid = $('#spreadsheet').closest(".pq-grid");
 $grid.pqGrid("copy");

var $grid1 = $('#tree_grid').closest(".pq-grid");
$grid1.pqGrid("paste");

[paramvir]

use Tab API to work with worksheets.

If you want to copy from sheet2, then activate and focus on sheet2 and then copy from it.

Code: [Select]

var T = this.Tab();
T.activate(1); //assuming sheet2 is at 1 index in tabs array collection.
var grid2 = T.grid( T.activeTab());
grid2.focus({rowIndxPage: 1, colIndx: 1});
grid2.Range({r1:1,c1:1, rc:2,cc:2}).copy();