How to loop through excel file and store that data to datatable?


#1

how to loop through excel file and store that data to datatable ?


#2

Do you wish to read data from the excel worksheet? Have you tried to use the “Read Range” activity? That returns a datatable as an output


#3

Hi @shivamrana,

To Loop through the excel file take Foreach Row Activity and try to use AddData Row activity in the loop and add some .NET extensions to work according to your requirement.

Thanks & Regards
A.Srish