Level 1 Foundation training, Lesson 9, Practice 1

Learn Academy Feedback
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:

output
output1903×667 31.6 KB

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!

Anyone?

Main.xaml (7.9 KB)

Match.xlsx (8.3 KB)

1 Like
2

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

3

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

4

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

image
image884×405 15 KB

see buddy that is wat it implies
image
image957×573 11.7 KB

for more details @bmildh

Hope this would help you
Cheers

5

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

1 Like
6

Thats great
Cheers
Keep going
@bmildh

7

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