how to put in zeros in the empty spaces of a matrix read by xlsread()?

I have a xlsx data sheet which needs to be imported as a matrix. I am using xlsread for the same. But many spaces in the dataset are empty which are read as Nan. I want to replace these values with zeros. I have tried to initialize the matrix as:

a = magic(100); a = xlsread(filename.xlsx);

But still the same problem as I believe the matrix gets resized after the import.

Debanjan

Answer 1

[per isakson]

Try

    M(isnan(M))=0;

&nbsp

In response to comments:

See the on-line documentation on xlsread. This is copied from one of its example

    values = {1, 2, 3 ; 4, 5, 'x' ; 7, 8, 9};
    headers = {'First', 'Second', 'Third'};
    xlswrite('myExample.xlsx', [headers; values]);
    [ndata, text, alldata] = xlsread('myExample.xlsx')

it returns

    ndata =
         1     2     3
         4     5   NaN
         7     8     9
    text = 
        'First'    'Second'    'Third'
        ''         ''          ''     
        ''         ''          'x'    
    alldata = 
        'First'    'Second'    'Third'
        [    1]    [     2]    [    3]
        [    4]    [     5]    'x'    
        [    7]    [     8]    [    9]

You are right ndata doesn't include the "header-rows", alldata does.

[Debanjan Dasgupta]

Thankx a lot per isakson.

But i think it did not solve my entire problem. My excelsheet contains initial 10 rows of empty cells which also needs to be replaced by zeros. But I think the xlsread function is not reading those rows and is making the 11th row containing values as the first row.

How to solve this?

[Image Analyst]

Prepend 10 rows (or however many you want) to the numerical data:

ndata = [zeros(10, size(ndata, 2)); ndata];

[Debanjan Dasgupta]

Thankx a lot per isakson. But after these steps, the size function is giving me errors. command used: rows = size(a, 1) Error: Subscript indices must either be real positive integers or logicals.

Error in buzsakiIInetwork_coherence_multifiles_multirows (line 26) rows = size(a, 1)

[Debanjan Dasgupta]

I could do it.. Actually there was some old variable size in the workspace but not in my script which was creating the trouble... Thankx a lot guys for all the help.. :)