Question

Pulling excel cell gives a result of '#######'

  • 29 December 2023
  • 1 reply
  • 37 views

Badge +1

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?


1 reply

Badge +1

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