Readtable skipping random rows in the excel sheet that I import into it

I try to readtable this excel file called database1, and as you can see, the readtable M creates a table that is 72 by 38 but that skips some of the rows in my excel sheet, which if I try importdata, it doesn't and create a 78 by 39 data sheet I have no clue why this happens, and this is the particular row of data that I wanted to use but it skipped over Please let me know if you know what's wrong

[Cris LaPierre]

It's hard to say anything conclusive without seeing the spreadsheet, too. Can you attach it to your post using the paperclip icon?

[David Zhang]

So I tried to do what you said, and it said it only accept xlsx format rather than xlsm, so I just copied everything to a xlsx sheet, and just as a troubleshooting step I used readtable on this document, and every row was taken in. Very weird but thanks anyways.

Answer 1

[David Zhang]

I just copied all the data from the xlsm sheet to an xlsx one and all of the readtable caught all the data when I used it on xlsx. Maybe not an ideal solution but I'm not complaining

[Cris LaPierre]

Interesting. Readtable is supposed to work on xlsm files, too.

• .xls, .xlsb, .xlsm, .xlsx, .xltm, .xltx, or .ods for spreadsheet files

Can you zip your xlsm file and attach it to you post? This may be worth passing along internally to our development team to see what is happening.

[David Zhang]

ok I added it :)