Level 1 Foundation training, Lesson 9, Practice 1

Ok, so I’m getting tired and it is quite possible I need to walk away and just take a break. Maybe I’m missing something completely obvious here.

Anyway, I took the Lesson 9, Practice 1, excel file and just wanted to play around a little. Here is pseudo code of what I did:

Open the file
ReadRange activity
For each Row in wordsDT
write line: row(0).toString
write line: row(1).toString
write line: wordsDT.Rows.IndexOf(row).ToString

Thats it! I’m just printing three things inside the ForEachRow activity.

Here is my output:

Please notice that the first thing that is read, “red:yellow” and that this is index 0.

However, looking at the excel file, the first row is actually “brown:red”

It’s like this row is never read at all!


Main.xaml (7.9 KB)

Match.xlsx (8.3 KB)

1 Like

Buddy @bmildh
May i know what was the issue you were facing

Hi @bmildh
I think you need to uncheck AddHeaders property of read range activity,
AddHeaders - When selected, the column headers from the specified spreadsheet range are also extracted. By default, this check box is selected.
By this it consider that the 1st record of the excel as headers
But here from my understanding, I think your 1st record is “brown:red”
So try it by unchecking AddHeaders option of read range activity

Buddy @bmildh
you know something…you were almost right buddy
no worries
its resolved buddy
here you go with xaml and xlsx file
Main (1).xaml (8.9 KB)
Match.xlsx (8.3 KB)

the reason was you have enabled the add headers in the read range activity tht would take the first row and column as headers and not as data…so on unchecking that you will get the data you want buddy
like this

see buddy that is wat it implies

for more details @bmildh

Hope this would help you

Thank you soooo much! I need to get some sleep now. Should have known better.
Anyway, much appreciated!

1 Like

Thats great
Keep going

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.