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

4 visualizaciones (últimos 30 días)
Anne Nguyen
Anne Nguyen el 27 de Oct. de 2019
Respondida: Ken Atwell el 28 de Oct. de 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!

Iniciar sesión para responder a esta pregunta.

Respuestas (1)

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

Categorías

Más información sobre Data Import and Analysis en Help Center y File Exchange.

Etiquetas

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by