清空筛选条件
清空筛选条件

Info

此问题已关闭。 请重新打开它进行编辑或回答。

xlsread returns error some times

1 次查看（过去 30 天）
Christian F.
Christian F. 2015-3-12
关闭： MATLAB Answer Bot 2021-8-20
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 个评论
BSantos
BSantos 2015-3-12
Can you shows us a bit of your code where the error is being generated?
Image Analyst
Image Analyst 2015-3-12
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?

此问题已关闭。

回答（1 个）

Christian F.
Christian F. 2015-3-12
编辑：Christian F. 2015-3-12
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.
  2 个评论
BSantos
BSantos 2015-3-12
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.
Christian F. 2015-3-12
Excuse me, T is simply defines as the number of rows I want to import, so it's numeric.

此问题已关闭。

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by