How to write excel loop columns?

[fairymemay (noona)]

If I want to write dtRow(0).tostring until dtRow(25).tostring
In excel column B- column Z (in row = rowData)

variable rowData as int = 5

Please guide me about it.

[Yoichi]

Hi,

Hope the following helps you.

Regards,

[vignesh.ks]

Hi @fairymemay

Please use ‘For Each’ activity and make ‘TypeArgument’ as system.Data.DataColumn

It will hydrate the column in the data table. And if you want till 25th index, then assign int variable in ‘For Each’ activity output.

Then inside the for each activity drop ‘If’ activity and give condition as intVariable<=25.

Please find the below workflow screen shot.

Thanks.