Forums Ignite UI for jQuery
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Guru Srini
95
Copying excel rows to grid
posted

Hi,

I've implemented the excel functionality on igGrid where by a I can copy rows from excel and paste it to the grid. I have not enabled filtering on the grid. I have problems pasting records into the grid when there are no rows. I'm not able to select the header in order to do a paste. I think the focusin event is not getting triggered when I click on the grid column header. Can you help?

I followed the below link:

https://www.igniteui.com/help/implementing-paste-from-excel

Regards,

Guru

Parents
No Data
Reply
  • 16310
    Offline posted

    Hi Guru,

    I am not able to reproduce the issue you describe.

    What I did is modify the sample from the link so that the grid is loaded with no records. Then I do the following steps:

    1. Copy cells from Excel spreadsheet
    2. Click on grid column
    3. Do Ctrl + V to paste the cells

    Please find the modified sample here.

    The above works fine. Please note that there is a dropdown above the igGrd where you choose how to do the pasting - pasting as new records or pasting starting from the active cell. The latter would not work, since the grid is empty and there is no active cell.

    Please let me know if you need any further help.

Children