error on 'tables=xl​sread(file​name);'

2 次查看（过去 30 天）
Allan N
Allan N 2019-2-19
评论： Allan N 2019-2-23
I am running 2013b version of matlab and recently upgraded to windows10 from windows 7 with excel2016 (previously excel2011). I am now getting error on this xlsread line, and was wondering if anyone might have suggestions as to why this error is now appearing?
  1 个评论
Steven Lord
Steven Lord 2019-2-19
What is the full text of the error message you receive? Include all the text displayed in red, and if there is also some text displayed in orange show that as well (please indicate which sections are displayed in red and which in orange.)

请先登录，再进行评论。

请先登录，再回答此问题。

回答（5 个）

Allan N
Allan N 2019-2-19
all in red
"undefined function or variable 'filename'.
Error in Template (line 25)"
Allan N
Allan N 2019-2-21
I'm attaching the screenshot.
Image Analyst
Image Analyst 2019-2-21
table is a predefined reserved function. You should not, and maybe cannot, assign the results of a call to xlsread() to it. Call it something else, like data.
Secondly, don't call xlsread() all those extra times - it just takes more time. You can get temperature, etc from "data" - the entire array as read in from your first call to xlsread().
Allan N
Allan N 2019-2-22
Untitled.jpgHere, I'm just trying to execute the command to xlsread(), and I'm getting an unspecified error. I'm not sure why.
  1 个评论
Image Analyst
Image Analyst 2019-2-22
Well this time it's saying "unspecified error". That could be anything.
Please attach the m-file and the xlsx workbook file.

请先登录，再进行评论。

Allan N
Allan N 2019-2-22
I'm attaching the m file and a xlsx file.
Thank you for your help!
  2 个评论
Image Analyst
Image Analyst 2019-2-23
Well I got down to line 94 when it said this:
'smooth' requires Curve Fitting Toolbox.
Error in TemplateHan (line 94)
intensity(:,n2)=smooth(intensity(:,n2),.10,'lowess');
so I got past the problem line for you. I think it must be some kind of path problem, like the file is not where you're specifying it to be.
Allan N
Allan N 2019-2-23
Wow! That's great! Are you running Win 10? The m-file runs without errors on Win 7. I think there is a difference in how matlab executes the 'xlsread(filename)' command in the two OS. I have both the m-file and xlsx file in the same directory, but in Win 10, Matlab can't find the xlsx file.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Startup and Shutdown 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by