I’ve been trying to pull certain cells from a .xlsx file that’s being downloaded automatically by a different bot. I’m specifically interested in the date values that appear in this spreadsheet. However, since the default column length is too short upon download, it appears as #######. I thought that maybe AA would recognize and pull the true value, but it ends up pulling the literal ###### string. I need to be able to compare the cell value. Is there a way I can pull the true value of the cell without having to manually go in and increase the column size? Any ideas?
Pulling excel cell gives a result of '#######'
![Collaborator Badge](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/eeb1807e-43ef-49be-9d57-ee7e35651ddc_thumb.png)
SOLVED: After messing with things, having the bot “Read Cell Value” instead of “Reading Visible Text” is what will give you the value you need. Simple fix, but at least it’s on the books here if anyone else finds trouble with this!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.