Importing data from excel file into column arrays

Hello all,

I would like to import data from my excel file (Say data.xlsx) to many arrays into Matlab. I tried to do it with the import option but I get many NaN (Not a Number) arrays.

What I would like to do is import all the columns of length of the first column. I would like the name of the array to be the text in the 5th row of each column and the numbers to start from the 6th row. Also I would like blank cells to be input as zero values after importing.

Any idea?