Info
La pregunta está cerrada. Vuélvala a abrir para editarla o responderla.
xlsread returns error some times
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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!
2 comentarios
BSantos
el 12 de Mzo. de 2015
Can you shows us a bit of your code where the error is being generated?
Image Analyst
el 12 de Mzo. de 2015
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?
Respuestas (1)
Christian F.
el 12 de Mzo. de 2015
Editada: Christian F.
el 12 de Mzo. de 2015
2 comentarios
BSantos
el 12 de Mzo. de 2015
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....
La pregunta está cerrada.
Ver también
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!