Readtable skipping random rows in the excel sheet that I import into it
조회 수: 8 (최근 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
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/656935/image.png)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/656940/image.png)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/656945/image.png)
댓글 수: 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!