XLS File Is Not Being Parsed Correctly

App Building
, ,
1

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).

image
image1304×752 87.2 KB

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:

image
image1304×803 80.3 KB

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.

2

For any other readers following along, @muezz and I looked more into this offline and found that the corrupt formatting of the file parsing was because Retool is expecting tabular data for xls files while the contents of the file provided is HTML. Upon changing the file extension to HTML, the file parses as expected.