How to only get certain parts of an Excel Spread using readcell?

조회 수: 1 (최근 30일)
Anne Nguyen
Anne Nguyen 2019년 10월 27일
답변: Ken Atwell 2019년 10월 28일
What I have so far is:
M = readcell('quiz_results.xlsx');
answerKey = M('G2:W2');
When I run this, I get a 1x5 cell, and when I open that, it says "1x1 missing". Why is it doing this and what would fix this? G2:W2 on the Excel Spreadsheet are letters: D B C B A C B D D B B A B B A D C (like for an answer key) if that makes a difference. Thank you!

답변 (1개)

Ken Atwell
Ken Atwell 2019년 10월 28일
Trying using the 'Range' option with readcell.


Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기



Community Treasure Hunt

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

Start Hunting!

Translated by