Thread Subject: dlmread problem

I am trying to read a file from Excel that has both text
and data values. The first three columns all have text in
them. I want to read the data from the first two columns,
but begin after the text in row 1. I have tried using
dlmread and telling MATLAB to skip the first row, but I
get this error:

??? Error using ==> textscan
Mismatch between file and format string.
Trouble reading number from file (row 1, field 1) ==>

This is the code that I used:

PIT_MKV_2 = dlmread('IndvsPP.xls','',[1,0,2,0]);

I also tried using this line of code to read the data, but
I get the same error. This is the code that I used:

PIT_MKV_2 = dlmread('Thisdata vs.
Thatdata.xls','','A2..B3');

I put a grey box in Column 3 of the Excel file to divide
the data, but I don't think that should make a difference.

--Ender--

"Ender " <jr147@msstate.edu> schrieb im Newsbeitrag
news:g4ine1$339$1@fred.mathworks.com...
>I am trying to read a file from Excel that has both text
> and data values. The first three columns all have text in
> them. I want to read the data from the first two columns,
> but begin after the text in row 1. I have tried using
> dlmread and telling MATLAB to skip the first row, but I
> get this error:
>
> ??? Error using ==> textscan
> Mismatch between file and format string.
> Trouble reading number from file (row 1, field 1) ==>
>
> This is the code that I used:
>
> PIT_MKV_2 = dlmread('IndvsPP.xls','',[1,0,2,0]);
>
> I also tried using this line of code to read the data, but
> I get the same error. This is the code that I used:
>
> PIT_MKV_2 = dlmread('Thisdata vs.
> Thatdata.xls','','A2..B3');
>
> I put a grey box in Column 3 of the Excel file to divide
> the data, but I don't think that should make a difference.
>
> --Ender--

Hi Ender,
dlmread reads ascii files. Use xlsread to read Excel files...

Titus