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: 1 year ago
Posted: 1 year ago
Ok. When we have more than 20 cells then how can we achieve it?
Posted: 1 year ago
Same approach only.
Posted: 1 year ago
Ok.Thank you Jayachandra.
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.