MATLAB Answers

0

problem in evalin with matlab app designer.

Asked by Oddineus on 19 Apr 2019
Latest activity Commented on by Oddineus on 19 Apr 2019
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

  1 Comment

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
thank you.

Sign in to comment.

0 Answers