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 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();


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