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…

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, Nishan…

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

Help Studio

system (system) Closed October 1, 2022, 3:43pm 3

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

Topic		Replies	Views
Read Range Activity did not read #N/A value in cells Studio studio , question , designer_canvas	4	121	July 30, 2024
How to filter excel data table which contains #N/A values Studio studio , question , activities_panel	14	17648	May 29, 2021
Preserve format enable Activities excel , activities , question	4	819	June 17, 2022
Filter Datatable Problem Robot robot , question	6	1030	July 6, 2022
Unable to get the Excel cell valu is like "#N/A" Activities excel , studio	8	1082	May 18, 2022

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

Related topics