Unable to get the Excel cell valu is like "#N/A"

Help Activities
,
1

Hi all,

in one scenarion I want to get the text available int he Excel like “#N/A”, can you help me on this
.
image

Thanks in advance

2

That means that there is no value, because there is an incorrect formula or data the formula uses is missing.

3

Thanks for Quick reply…

yes I agree, but in the Column we have to identify #N/A text and has to process further based upon this value… so the reason I want to extract the that value from that cell

Thanks

4

Hello @srinusoft37

Currently if you are reading this table how the values are retrieving? Is it a blank values?

5

use filter data table acitivity or datatablevariable.select(“‘columnname’=‘n/a’”).copytodatatable()

6

Yes manully I enter the “#N/A” value in to the Excel cell and trying to get the value. will this will not work ?

Thanks

7

No. That #N/A is not an entered value. It’s Excel telling you there is an error.

Use a spreadsheet that naturally has the #N/A - what does Read Range/Read Cell give you as the value?

1 Like
8

Ok thanks for the clarification

Thanks

9

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