problem in evalin with matlab app designer.

Hello everyone.

im running an .mlapp which will create Excel file and save data on it, im using xlswrite1 to do it.

so the problem is i get this message every time i save the data to the Excel file.

'Error using evalin

Undefined function or variable 'Excel'.

Error in xlswrite1 (line 2)

Excel=evalin('base','Excel');'

why? and how to solve it.

My Code:

% Saving the data:
app.NEW3='Results';
SubjectNumberH,=1000;
Excel = actxserver ('Excel.Application');
folder = pwd;
baseFileName =app.NEW3;
fullFileName = fullfile(folder, baseFileName);
ExcelWorkbook = Excel.workbooks.Add; 
ExcelWorkbook.SaveAs(fullFileName,1); 
ExcelWorkbook.Close(false); 
invoke(Excel.Workbooks,'Open',fullFileName);

xlswrite1(fullFileName,SubjectNumberH,);

invoke(Excel.ActiveWorkbook,'Save'); 
Excel.Quit 
Excel.delete 
clear Excel

[Oddineus]

i got the answer.

for people with the same issue try to oppen the function file xlswrite1 and then replace the first line

Excel = evalin('base','Excel');

with

try 
Excel = evalin('caller','Excel'); 
catch err 
Excel = evalin('base','Excel'); 
end

Source

thank you.

[Alexander Kornegay]

Thanks for sharing. This saved me a lot of time!