Read blank row as 0

What function in MATLAB can I use that reads an excel line and plots 0 when it has a blank space

Answer 1

[Matt Fig]

Blank rows are read as nans with xlsread. So use

N(isnan(N))=0

[Rodrigo Trigona]

Sorry,I didn't understand how can I use this to read the blank spaces as 0.

[Matt Fig]

N is the output from xlsread, assuming you have numeric data. See the help for xlsread.

help xlsread

[Image Analyst]

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?