Announcements
SomeDataTable is a datatable.
SomeColumnName is a String.
Is it possible to get value like
For Each SomeDataRow in SomeDataTable
%SomeDataRow["%SomeColumnName%"]%
if i'm wrong then correct me, you want to read excel row one by one column wise ?
Yes. I'm trying %SomeDataRow[%SomeColumnName%]%
%SomeDataRow[SomeColumnName]% pass the code checking, but runtime error as
Could not found column or attribute '"ColumnName"'.
Quote of quote String. The behavior is mysterious.
as per my understanding, you will need to first read your excel row's and column then you will get " excel data " variable , 2. apply for each action and use "excel data" variable so you will get current item variable (whole row's in data table ) 3. use anther for each under the 1 st for each loop and use "current item " variable, use display msg box to check your output.
Put it like this:
%SomeDataRow[SomeColumnName]%
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 262 Super User 2026 Season 1
11manish 167
Haque 154
