Object Reference not found but object is created

i have used read range activity to read file and use its value for further use but it is showing object reference not found

@Prateek_Gulab_Pathak

If your datatable is config then use as below

Config.rows(0)(1).ToString for the first row and aecond column

Cheers


i have tried that also now its showing no rows

@Prateek_Gulab_Pathak ,
Can you Please check the row Count of Config and let us know what is the output

RowCount = Config.Rows.Count

Regards,

Hi @Prateek_Gulab_Pathak

As @Anil_G explained above, the first pharentesis will refer to the row, second will refer to the column, datatable start from index 0.

So, please check if your datatable contains data besides the column names, based on that you can retrieve the element you want using the code

Config.rows(0)(1).ToString
Config.rows(RowIndex)(ColumnIndex).ToString

Regards

@Prateek_Gulab_Pathak

Check if your datatable has the values are not

Use If condition as Config.Rows.Count > 0

Then write as below

Config(0)(0).Tostring - to get the First row of the First Column value

Hope this may help you

Thanks,
Srini

Thank You Everyone for your help.
it worked now .

1 Like

@Prateek_Gulab_Pathak

Then from the locals panel can you please open the config datatable and chekc if there are any rows or does it have only headers

Cheers

@Prateek_Gulab_Pathak ,
Can we know what was the issue then?

Regards,

it was my mistake only the sheet reference was not proper sorry for the inconvenience.And thank For the time.

1 Like

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