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

2 views (last 30 days)
Anne Nguyen
Anne Nguyen on 27 Oct 2019
Answered: Ken Atwell on 28 Oct 2019
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!



Community Treasure Hunt

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

Start Hunting!