Hi All,
i have an excel where theres a value of # VALUE
that will occasionally appeard,
and seems like my read range activity unable to read it.
is there a way to bypass this exception and still read the excel ?
thank you
Hi @Ahmad_Rais
Yes, you can bypass it.
Put the Read Range inside a Try Catch so the process doesn’t stop.
Use Workbook Read Range instead of Excel Read Range — it usually reads value! without error.
If possible, fix the Excel by using IFERROR in formulas or replacing formulas with values.
Simplest solution: Workbook Read Range + Try Catch.
i try using workbook read range already but cannot read
and i cant adjust formula because its coming from vendorrs
Hi,
Can you try to update Excel pack to the latest?
In my environment (Studio25.10.4 + Excel 3.3.1), #VALUE! can be read.
Sample
Sample20260120-1.zip (10.7 KB)
Regards,
Use Excel Application Scope, not Workbook.
Before Read Range, add Calculate activity.
Then use Read Range.
Sometimes Excel has pending calculations from vendor formulas.
Calculate forces Excel to evaluate them, so Read Range won’t fail.
If it still fails:
- Use Try Catch and skip the bad row
- Or read cell-by-cell instead of full range
Hi @Ahmad_Rais
place a Read Range activity inside Use Excel File and set Preserve formatting to Off so that the data is extracted as plain text instead of throwing an exception.
Another way is to use Workbook Read Range instead of Excel Read Range because workbook activities do not evaluate formulas and can read cells even if value! is present.
Happy Automation
Hi ,
i found this when i test using my file
Read Range: Exception has been thrown by the target of an invocation.
for context this cell have formula to calculate value from diffrent sheet
@Ahmad_Rais - Can you work with a copied version of excel? Copy and move the excel file to a different folder - run a small VBA script to convert data to values format/remove value
and read it. You can repeat this logic before starting the process and if you want to update the actual file - you can again execute macro and update it.
