I have two XLS files. Both are server generated. One is from our bank (account statement) and the other is an internal ledger report from our company's web portal. I am trying to read both files within my Retool app.
The first one is read successfully using the following piece of code (ignore the splices. I am just getting rid of some useless rows).
As you can see, I am getting the correct data from this file (visible in the table).
Now if I try the second file, I get this:
As you can see, the parsed value is showing some strange values. I do not know what to do here. I would really appreciate it if someone could point me in the right direction.