problem in evalin with matlab app designer.

2019 4 19
0 个回答
更新时间：2020 9 14
5 次查看（30 天）

1 个投票

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

2 个评论
显示 无 隐藏 无

Oddineus
Oddineus 2019-4-19
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
Alexander Kornegay 2020-9-14
Thanks for sharing. This saved me a lot of time!

请先登录，再进行评论。

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

回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by