Read Range Activity did not read #N/A value in cells

Help Studio
, ,
1

I am using Read Range Workbook Activity to read a two column table in an Excel Spreadsheet to a DataTable and then print it out in a Sheet in another Workbook. I noticed that cells with the value “#N/A” are not being printed. They are empty, no values in them. The “#N/A” values are to be looked up and brought into another table. So I need the “#N/A” values.
This is the view of the Excel that has the “#N/A” values
image

This is what I get after I read via Read Range and print it out

image
image332×501 11.7 KB

I shall be grateful if someone can help me. If the information I have provided is not enough, kindly let me know.

2

Hi @RobinsonFrancis

Usually #N/A is treated as error value so it will become empty when copied to another sheet using read range. For this, you need to enable Preserve Format in read range.

Thanks,
Aravind

3

#N/A is not a value. It’s an error in Excel. It could just mean that you don’t have the column wide enough to see the value, or the formula is wrong, or does not return a value. You can use an If in the formula to return a standard value (like “Not found”) if no value is returned.

4

HI @RobinsonFrancis

Please check the below thread:

Regards

5

@RobinsonFrancis

Three ways that I could give you

  1. Instead of seaeching #N/A search for blank only as it means the same
  2. try using read range with display values setting
  3. Try to use copy paste with values and then read

Cheers