I have an excel template which doesn’t have a structure and I want to update certain rows in the excel using the data from another excel sheet . So i read the other data from excel sheet as a datatable and later loop through the template to fill data into it but that doesn’t happen since the template doesn’t have a structure . Can anyone please help me with that?
Please refer the screenshot of the template . In the rows (a) (b) (e) (f) I need to update data row by row.
template.xlsx (16.6 KB)