Read blank row as 0

1 visualización (últimos 30 días)
Rodrigo Trigona
Rodrigo Trigona el 26 de Sept. de 2012
What function in MATLAB can I use that reads an excel line and plots 0 when it has a blank space

Iniciar sesión para responder a esta pregunta.

Respuestas (1)

Matt Fig
Matt Fig el 26 de Sept. de 2012
Blank rows are read as nans with xlsread. So use
N(isnan(N))=0
  3 comentarios
Mostrar 1 comentario más antiguo
Matt Fig
Matt Fig el 26 de Sept. de 2012
N is the output from xlsread, assuming you have numeric data. See the help for xlsread.
help xlsread
Image Analyst
Image Analyst el 27 de Sept. de 2012
N = xlsread(filename);
Where there is a blank cell in the Excel worksheet, N will be NaN at those locations, and N will have valid numbers at other locations where you have valid numbers in the worksheet. Matt's code changes those matrix locations with NaN's in them from NaN to 0, as you requested. Understand?

Iniciar sesión para comentar.

Categorías

Más información sobre Spreadsheets en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by