This is really good HBA.... but it works only for 1 row.... i mean when i copy when i copy bunch of rows frm Excel to grid. it's only the first row data getting pasted correctly in appropriate columns.... other rows are not considered.

What i can do ???? Pls reply

Try this code

    function UltraWebGrid1_BeforeClipboardOperation(gridName,operationType,options )

    {

    if(operationType != igtbl_ClipboardOperation.Paste)

        {

        return true;

        }

    var copiedData = igtbl_getClipboardData();

    var copiedCellValues = copiedData.split('\t');

    if(copiedCellValues.length != 13)

        {

        alert('Wrong paste');

        return true;

        }

    var grid= igtbl_getGridById(gridName);

    var band = grid.Bands[0];

    var row = grid.getActiveRow();

    var gridCellNum = 0;

    var copiedValNum = 0;

    while(copiedValNum < 13  )

        {

            /*Paste if cell is not read only*/

            if(band.Columns[gridCellNum].AllowUpdate != 2)

                {

                 row.getCell(gridCellNum).setValue(copiedCellValues[copiedValNum++]);

                }

            gridCellNum++;

        }

    return true;

    }

Let me know if this is helpful to you.