Before I post something about this:

does anyone know how to read an excel file with matlab and manipulate it?

I know how to open it and put it in different categories:

[num txt raw] = xlsread('c:\matches.xls')

NEED HELP ON THESE THOUGH:

Count the number of entries that have one blank field

Copy these entries in a new array that you display in order to review and verify the errors

Finally you decide to remove these defective entries from your array (for which one field was left blank) by
copying only the valid entries to a new array, which is going to be your working database





http://www.sendspace.com/file/q1dp3j - excel file .xls

 

Does the file have to be saved as an Excel file?

Can you save it as a comma delimited format, then import the data?

 

i believe it has to be saved as an excel file

 

actually maybe i can copy and paste into a text file and read it from there?

 

you can choose save as text file like retched said from excel

than comma delimit it.

open text with matlab

in matlab

load filename.txt

that is it. then just put filename(row numbers,column numbers)

for example i want all data in column 1
matlab syntax

filename,1)

 

What's the problem with xlsread? It's pretty convenient...

 

Aww, thats too easy.