Hello Indra,

After further investigating this matter, I have prepared a small sample by following the step-by-step guide in our Implementing Paste from Excel in igGrid topic here and configuring some of the columns to be fixed.

The difference is in the custom getVisibleColumns function as it returns the visible columns after being fixed which causes the reordering when assigning the processed Excel data to the corresponding cell.

The columns with their original order are retrieved on the igGrid’s created event by using the igGrid’s _columns property.

// get visible columns

var visibleColumns;

$(document).on("igcontrolcreated", "#grid", function (evt, ui) {
    var columns = [];
    
    $(ui.owner._columns).each(function () {
        if (this.hidden !== true) {
            columns.push(this);
        }
    });
    
    visibleColumns = columns;
});

The result could be observed in the attachment below:

Additionally, attached could be found my sample for your reference along with the sample Excel file. Please test it on your side and let me know how it behaves.

Looking forward to your reply.

Sincerely,
Riva Ivanova
Associate Software Developer

4760.pasteFromExcel.zip

8484.sample-data.xlsx

After looking into your question, what I could say is that if you have used the step-by-step guide and sample demo in our Implementing Paste from Excel in igGrid topic here as a reference for implementing this functionality, then this topic aims to demonstrate a possible approach on how to implement paste from Excel with the igGrid control.

It is fully implemented on the application level and is not explicitly intended to work for all possible scenarios, such as copying and pasting the data for a certain column from Excel. This may require additional configuration which should be handled entirely by the developer on the application level.

However, I have tested the described behavior with the previously attached sample, and, on my side, I am not able to reproduce it.

This could be observed in the attachment below:

Attached could be found a working sample with the newly added configuration from my previous message.

Additionally, in case you continue to experience this behavior, please note that this does not seem directly related to our controls and is more related to custom implementation and could be considered beyond the scope of Infragistics Support.

Sincerely,
Riva Ivanova
Associate Software Developer

1563.paste-from-Excel-to-igGrid.zip

3010.igGridPasteFromExcel.zip