How can I import the leading string rows or columns of an Excel worksheet?

I try to import an Excel application form that has text and numerical values. XLSREAD trims the leading rows and columns of text. I would like to know how to circumvent that.

Answer 1

[MathWorks Support Team]

Download the attached function (MODxlsread.m) and save it to the same directory as XLSREAD.

To find the directory of XLSREAD, type the following at the MATLAB command prompt:

which -all xlsread

Call MODxlsread instead of XLSREAD to allow the leading rows and columns of text in the Excel sheet to be imported.

Restart MATLAB or execute the following command to update the function cache in MATLAB of the new function:

rehash toolboxcache