to read .xls file

I have a alphabetical (string) data in .xls file. I want to read it and do some analysis. How can I read separate column/cell for analysis?

[Jan]

What does "alphabetic string" mean and how is it stored in the Excel file? One character per row, per column, or the complete string in one cell?

[varsha]

complete string in one cell. size of file it is giving as 855*7. It is getting loaded in workspace. but how can I read it cell wise and compare and do analysis?

Answer 1

[Alessandro Masullo]

http://uk.mathworks.com/help/matlab/ref/xlsread.html

[varsha]

It does not work. ex. data in first column is names of images, second column is image parameters and so on... I want to read it and do some analysis. ex. comparing 2 image names. How can I read separate column/cell for analysis?

[Star Strider]

If you want the string data, you have to ask for at least 2 outputs from xlsread. The string data will be in the second output.

[Jan]

@varsha: xlsread does work. It is simply the right tool to import the contents of an Excel file. If you observe any problems, post your code and the error message or a detailed explanation of the difference between the results and your expectations.

[varsha]

Thanks!! Star Strider and Jan Simon,

I have used xlsread in following way:

[num,txt,raw] = xlsread('file.xls',1,'D1:D20');

and used for loop to read individual cell in 'txt', like

for i=3:7 disp(txt(i)); end

Thanks!

[Star Strider]

My pleasure!

[Image Analyst]

Alternatively you could have used readtable().