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

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?

[Steven Lord]

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.)

Answer 1

[Allan N]

all in red

"undefined function or variable 'filename'.

Error in Template (line 25)"

Answer 2

[Allan N]

I'm attaching the screenshot.

Answer 3

[Image Analyst]

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().

Answer 4

[Allan N]

Here, I'm just trying to execute the command to xlsread(), and I'm getting an unspecified error. I'm not sure why.

[Image Analyst]

Well this time it's saying "unspecified error". That could be anything.

Please attach the m-file and the xlsx workbook file.

Answer 5

[Allan N]

I'm attaching the m file and a xlsx file.

Thank you for your help!

[Image Analyst]

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]

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.