Closed
Solved
populate textboxes from excel
I have a requirement where I need to populate the excel row values to their respective textboxes. I am getting the values from getitem into message box. But how can I populate the values from row to their respective textboxes? Please help me with the solution.
Thanks & Regards,
Anu
Accepted Solution
Posted: 3 years ago
Infosys
Infosys
IN
You can export excel data to datatable using exportdata and then loop the datatable rows and read required row values or you can use excel getcellvalue method for each cell.
for ex: if you want read first row values then pass A1, B1, C1 to getcellvalue method based on no of cells.
Posted: 3 years ago
Staidlogic
Staidlogic
IN
Ok. When we have more than 20 cells then how can we achieve it?
Posted: 3 years ago
Infosys
Infosys
IN
Same approach only.
Posted: 3 years ago
Staidlogic
Staidlogic
IN
Ok.Thank you Jayachandra.