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

5 views (last 30 days)
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!

Answers (1)

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

Categories

Find more on Data Import and Analysis in Help Center and File Exchange

Tags

Products

Community Treasure Hunt

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

Start Hunting!