Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

how to copy more than 5000 records from excel to itemmatrix

Hi experts,

I have excel sheet with 5000 records.and need to be add these records with UDO.

so i want to show 5000 record to show in itemmatrix.

i am trying to show these records through looping.

for that initially i am copying excel data into C#.net datatable and then datatable to itemmatrix

but it is taking 20 min.

is there any way to fill excel to itemmatrix in faster way

here is my code:

for (int i = 0; i < dt.Rows.Count; i++)//here datatable contains 5000 rows

            {

            

                SAPbouiCOM.EditText Id = (SAPbouiCOM.EditText)oMatrix.Columns.Item("V_-1").Cells.Item(i + 1).Specific;

                SAPbouiCOM.EditText oEdit1 = (SAPbouiCOM.EditText)oMatrix.Columns.Item("V_1").Cells.Item(i + 1).Specific;

                SAPbouiCOM.EditText oEdit2 = (SAPbouiCOM.EditText)oMatrix.Columns.Item("V_2").Cells.Item(i + 1).Specific;

                Id.Value = (i + 1).ToString();

                oEdit1.Value = dt.Rows[i][0].ToString();

                oEdit2.Value = dt.Rows[i][1].ToString();

            }

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question