Hi Team,
We have a process where we need to read data from Macro enabled file and enter the values copied from this file to some web based application but when BOT is trying this it is entering the values as “name?” kind of error values instead of actual values in the file. So could you please help how to fix this?
Version of Excel using is 2016 and we observed that file is password protected.
The error values you are getting indicates that the values are returned by some formula and that formula is not working.
Check if there is any external file or link dependency which isn’t working.
Thanks! No we don’t have any such dependencies but as I said it is password protected and also when we click enable editing for that file manually also we see these kind of error values instead of actual values in the file. So, will there be any work around to fix this or please confirm if the version of excel that is 2016 is causing this issue. As we are hoping that upgrade of Excel to Office 365 will solve this. So, please suggest.
I don’t think this could be an issue but if you can easily upgrade excel version, there is no harm in trying that approach as well. Do post your finding after.
May i know how you are reading the value from excel??
Try different methods available in UiPath to see the results
Example - Use Read Range (Excel) instead of Read Range (Workbook)
Also is it coming as expected in the excel and the issue is while reading using UiPath only?
Check VBA macro.
At the end of code, put below lines
Application.Calculation = xlCalculationManual
Application.CalculateBeforeSave = True
Hi @Rama_Thota
Try below,
Use Excel Application Scope with the correct password, enable the “Visible” and “ReadOnly” options, and make sure “Enable Macros” is allowed in Excel settings. Use “Read Cell” or “Read Range” activities inside the scope to fetch data properly from the XLSM file..
If you found helpful please mark as a solution. Thanks
Happy Automation with UiPath