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

5 ビュー (過去 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 Center および File Exchange で Data Import and Analysis についてさらに検索

タグ

製品

Community Treasure Hunt

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

Start Hunting!

Translated by