Object reference not set to an instance of an object eror

[Duygu_Ozdemir (Duygu Özdemir)]

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.

[Gokul001 (Gokul Balaji)]

Hi @Duygu_Ozdemir

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

Can you please share the Workflow?

Regards
Gokul

[pravin_calvin (pravin kumar)]

Hi @Duygu_Ozdemir

Check with the datatable count

Dt.Rows.count

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

Regards

[Duygu_Ozdemir (Duygu Özdemir)]

Main.xaml (31.1 KB)

[Duygu_Ozdemir (Duygu Özdemir)]

hello, i am a bit of an amateur

I tried to do what you said. but still gave the same error

[pravin_calvin (pravin kumar)]

@Duygu_Ozdemir

Refer the xaml below.

Main (6).xaml (34.0 KB)

Regards

[pravin_calvin (pravin kumar)]

Hi @Duygu_Ozdemir

Does the above works for you?

Regards

[Duygu_Ozdemir (Duygu Özdemir)]

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.

[pravin_calvin (pravin kumar)]

@Duygu_Ozdemir

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

Does the count of the rows are greater than zero?

Regards

[Duygu_Ozdemir (Duygu Özdemir)]

sahibindenExcel.xlsx (11.4 KB)

[pravin_calvin (pravin kumar)]

Hi @Duygu_Ozdemir

Please refer the screen shot below.

seems the Excel has value.

Regards

[Duygu_Ozdemir (Duygu Özdemir)]

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

[pravin_calvin (pravin kumar)]

@Duygu_Ozdemir

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

Pass OutDtFOSL in for each row

Regards

[Duygu_Ozdemir (Duygu Özdemir)]

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?

[Duygu_Ozdemir (Duygu Özdemir)]

Main.xaml (33.2 KB)

[Duygu_Ozdemir (Duygu Özdemir)]

it happeneddd. I did. thank youu so much.

[pravin_calvin (pravin kumar)]

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

[Duygu_Ozdemir (Duygu Özdemir)]

thank you so much