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

5 vues (au cours des 30 derniers jours)
Anne Nguyen
Anne Nguyen le 27 Oct 2019
Réponse apportée : Ken Atwell le 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!

Connectez-vous pour répondre à cette question.

Réponses (1)

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

Catégories

En savoir plus sur Data Import and Analysis dans Help Center et File Exchange

Tags

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by