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