MATLAB Answers

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

10 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!

  0 Comments

Sign in to comment.

Answers (1)

Ken Atwell
Ken Atwell on 28 Oct 2019
Trying using the 'Range' option with readcell.

  0 Comments

Sign in to comment.

Sign in to answer this question.

Tags

Products