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

7 次查看(过去 30 天)
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
  2 个评论
Cris LaPierre
Cris LaPierre 2021-6-17
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
David Zhang 2021-6-17
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.

请先登录,再进行评论。

回答(1 个)

David Zhang
David Zhang 2021-6-17
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
  2 个评论
Cris LaPierre
Cris LaPierre 2021-6-17
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.

请先登录,再进行评论。

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by