xlsread returns error some times

Hi,

I have a little Problem with xlsread. When I use xlsread to import data, I sometimes get the error message:

    Error using xlsread (line 247)
    File C:\Users\...\UK.xls not in Microsoft Excel Format.

The file exists and the file name is correct. When I run the code a couple of times, it usually works. So the error occurs only some times. Any suggestions how to fix this?

Thanks in advance!

[BSantos]

Can you shows us a bit of your code where the error is being generated?

[Image Analyst]

Does it open using Excel? Can you attach the workbook here so someone can try it? Can you attach your script? Can we just put xlsread() in a for loop and observe the problem on some iterations?

Answer 1

[Christian F.]

Some code:

fname=strcat('C:\Users\...\',country); T = length(vector);

firstRow = 1; lastRow = T; firstCol = 'B'; lastCol = 'C'; cellRange = [firstCol,num2str(firstRow),':',lastCol,num2str(lastRow)]; [~,~,unique_geo_labels_new] = xlsread(fname,'Tabelle1',cellRange);

As I said before, some times it works, some times it doesn't. Very strange.

[BSantos]

One thing I notice is that you assign lastRow as T but not within commas; lastRow = T -> lastRow = 'T'

Plus, you do num2str(lastRow), but lastRow is not a number on th ecode you just shared.

Other than that, I don't see why xlsread does not work....

[Christian F.]

Excuse me, T is simply defines as the number of rows I want to import, so it's numeric.