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
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?
回答(1 个)
David Zhang
2021-6-17
2 个评论
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.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!