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

6 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 Spreadsheets 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