Loop through columns

[Sweety_Girl]

loop through in the columns like

A, B, C, D,… AA, AB,AC,… BB,BC

How to achieve this through logic?

[ppr (Peter Preuss)]

in datatable or Excel?

[Sweety_Girl]

Datatable

[ppr (Peter Preuss)]

@Sweety_Girl

classical:
for each - typeargument set to DataColumn - Expression YourDataTableVar.Columns

with LINQ e.g. getting all Colnames: YourDataTableVar.Columns.Cast(Of DataColumn).Select(Function ( c ) c.ColumnName).toArray

[Sweety_Girl]

I mean like…

I am using read cell activities,
Looping through rows are like A1, A2, A3 …A100
meanwhile, how to do that with columns , which will be like this,
A1, B1,C1…AA1,AB1

[ppr (Peter Preuss)]

I am not sure If I got you right:
YourDataTable.Columns(ColIndexOrColumnName) let you access the a particular Column

[supermanPunch (Arpan)]

@Sweety_Girl

A1, B1,C1…AA1,AB1

@Sweety_Girl I don’t think these are present in Datatable , You might be again referring to the Column Reference in the Excel

[Pratik_Wavhal]

Hi @Sweety_Girl

I have one mini bot created which can go through the columns beyond Z to AA AB… and so on

Input for my bot was as below. Reading from column B to AE

Logic for the same is as below :-

Within ForEachRow Activity :-

Within ForEach Activity for Columns :-

If it goes beyond Z column then :-

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal