How to read #N/A values using the read range activity for the Excel Application Scope

Help Studio
1

Hello Good People,

Need some support am trying to read an excel file using the Excel Application Scope read range activity but it does capture the #N/A values in the worksheet yet I want to filter them out.
When I tried using the read range workbook activity it does the job but it takes very long.
But when I only returned the column with the NA values in my DataTable I realized it was reading it as a negative as shown in the screenshot below but when I return the entire DataTable with all the columns that particular column with the NA values returns empty.
image

Please advise.

Thank you
Kakooza Allan Klaus

2

Hi @Kakooza-Allan-Klaus ,

As per - C# Interop.Excel '#N/A' Cell Value converted to -2146826246 - Stack Overflow - it seems that -2146826246 is the code for #NA in Excel.

Check the PreserveFormat property to get #NA instead of the negative number
image

Let me know if this helps

Thanks,
Nishant

1 Like
3

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