Hello all, I have excel sheet which contain in sheet 1
Abhishek
swati
Manoj
Mahesh
having this 4 names . I want to display this one by one in message box
how it is possible
Read range the excel
Use For each row in datatable
Use message box Currentrow(“YourColumnName”).toString
Regards
Hii ,
First use read range , assign one output variable that will be in datatable.
Take for each row for declared datable, then in for each row take message box activity pass “row(“Columnname”).tostring” or “row(rowindex).tostring”
this will print your output
it gives error. like non invocable member ‘CurrentRow’ can not be used like method
gives error in message box
yes i did this one i take excel scope application and then read range and then for loop
bt still it gives error in message box
My error getting solve using this
CurrentRow[“Company Name”].ToString()
Thank you for co operate .
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.