Object reference not set to an instance of an object eror

Help Studio
1

image
image1808×770 56.8 KB

For Each Row in Data Table: Object reference not set to an instance of an object.

I’m getting this error even if I don’t define inside the foreach. First thing I need to do is pull data from excel file in string form. I want to fill the necessary places in the browser with the data I have taken. but even if i disable the foreach’s content i get this error. Do you have a problem with identification?
can you help me. I tried many things but it didn’t work.

3

Hi @Duygu_Ozdemir

  • In For Each Row in Data Table → Check the dt value

Can you please share the Workflow?

Regards
Gokul

1 Like
4

Hi @Duygu_Ozdemir

Check with the datatable count

Dt.Rows.count

If the count is greater than zero proceec with iterating the rows.

Regards

1 Like
5

Main.xaml (31.1 KB)

6

hello, i am a bit of an amateur :frowning:
image
I tried to do what you said. but still gave the same error

7

@Duygu_Ozdemir

Refer the xaml below.

Main (6).xaml (34.0 KB)

Regards

1 Like
8

Hi @Duygu_Ozdemir

Does the above works for you?

Regards

1 Like
9

hello, I tried the main file you sent, and I entered the excel url, but I still get the same error. screenshot is as follows.

image
image1371×766 35 KB

10

@Duygu_Ozdemir

If possible can you share the file that you re using?

Does the count of the rows are greater than zero?

Regards

1 Like
11

sahibindenExcel.xlsx (11.4 KB)

12

Hi @Duygu_Ozdemir

Please refer the screen shot below.
image

seems the Excel has value.

Regards

1 Like
13

Main.xaml (18.7 KB)
can you see if it still works for you
it gives me a foreach error again

14

@Duygu_Ozdemir

You have chose a wrong dt varible to iterate in for each row.

image
image1425×745 45.5 KB

Pass OutDtFOSL in for each row

Regards

1 Like
15

yess it worked. Where is the error in my own project, how do I fix it. I tired you a lot, but if you have time can you take a look?

16

Main.xaml (33.2 KB)

17

it happeneddd. I did. thank youu so much. :slight_smile:

18

Hey @Duygu_Ozdemir

Click on the Read Range in the excel application scope

and click on the Variable Pane .

Delete the Duplicated dt Variable.

Regards

1 Like
19

thank you so much :slight_smile:

21

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