Error on reading range using workbook

Read Range Workbook: Object reference not set to an instance of an object.

Properties
image
image

Error encountered:

I tried updating package and still the same. I can’t use other activity because it requires excel license

TIA

Hi @joscares

Are you using any variable in your Workbook path property? please check it contains a valid value

Regards!

NO i just use plain string as path same for all other needed properties all plain string

Hi @joscares

Try removing the Range and running the workflow.

Regards

It results to 0 row count and also tried “A5:I5” it returns 0 row count but it has value on excel

Hi @joscares

If possible can you share the screenshot of the excel.

Regards

@joscares,

The Range you have given A5:I doesn’t make sense, specify the range like “A5:I2” or Whatever the range you would like to specify to get the cell values

The excel should have the values at the specified range

Hi @joscares

In the range give "A5" and run your flow. This should work.

Regards

Hi @joscares ,

The error is because of the invalid range used in Read range workbook activity

You can try specifying just “A5” or “A5:I34”

Hope it helps you out!

This works thank you!

Range A5:I works before but now it seems not anymore

TY!

1 Like

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