Hi guys, I’m a bit confused by something a user just spotted and was wondering if someone had encountered something similar.
I was using “Read Cell” and using arguments for File to open, sheet and cell reference, but it was pulling it incorrectly - the file says Nov, but UiPath read Oct? So I popped this activity into a sandbox and manually put in the arguments - same result, Oct. However, when I then used an “Excel Application Scope” (ie it is now opening the file) it correctly read as Nov…why the difference when opening it?
I’d rather not open the file as it’s quite meaty and takes a while, hence why I was using Read Cell to begin with, but if the only way I can do this is to open it then fine. The cell is based on a formula to find the previous month, could it be related to this? Interesting note is that it appears to read two other formula based cells correctly, for year and another flag, just month is coming out wrong.