GUIDE GUI export data to Excel

2018 8 17
1 个回答
回答已采纳
更新时间：2018 8 17
4 次查看（30 天）

0 个投票

Hello,
I've created a GUI in GUIDE and on the push of a button, I want to transfer data saved within the MATLAB 'base' workspace to an Excel file. I'm aware I can do this from the command window using the following code:
xlswrite('Vehicle_Data_', velocity_data, 'Sheet 1', 'A1')
However, how do I implement this within my pushbutton callback shown below:
% --- Executes on button press in pushbutton12.
function pushbutton12_Callback(hObject, eventdata, handles)
% hObject handle to pushbutton12 (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
Ideally, an example would be a massive help!
Thanks,
Craig

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Stephen23
Stephen23 2018-8-17
编辑：Stephen23 2018-8-17
"I want to transfer data saved within the MATLAB 'base' workspace to an Excel file"
Magically grabbing data from another workspace and magically accessing variable names is one way that beginners force themselves into writing slow, complex, buggy code which is hard to debug. The best solution is to pass that data properly as input/output arguments, exactly as the MATLAB documentation recommends:
https://www.mathworks.com/help/matlab/matlab_prog/share-data-between-workspaces.html
https://www.mathworks.com/help/matlab/creating_guis/share-data-among-callbacks.html

请先登录，再进行评论。

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

 采纳的回答

Adam Danz
Adam Danz 2018-8-17

0 个投票

evalin()
From your bushbutton callback you can evaluate the expression from the base workspace. If you get stuck, follow-up and I can help.

6 个评论
显示 4更早的评论 隐藏 4更早的评论

Craig Saunders
Craig Saunders 2018-8-17
Hi Adam, Thanks for your answer. Ideally, i would like to push a button on my GUI, and then it'll save data which was stored from a simulink simulation to an Excel file.
My simulation transfers this data to the workspace, however i just need to find a way of using
xlswrite
to then send this data to Excel.
Adam Danz
Adam Danz 2018-8-17
Yep, that's what I understood. evalin() is a solution.
One option is to get the needed data from the workspace and transfer it to your callback function using evalin. Then you can call xlswrite() from the callback function.
Here's an example of getting the variable named 'myVar' from the workspace to the callback function. You would grab all of your needed variables and then call xlswrite().
% (from callback function)
myVar = evalin('base', 'myVar');
The second option is to call xlswrite() from the base workspace (using evalin).
Here's how that might look.
% (from callback function)
evalString = 'xlswrite(''Vehicle_Data_'', velocity_data, ''Sheet 1'', ''A1'')';
evalin('base', evalString)
Craig Saunders
Craig Saunders 2018-8-17
Absolutely spot on, Adam. Thank you.
Craig Saunders
Craig Saunders 2018-8-17
On a quick note, if i wanted to export multiple data sets such as 'force_data', 'distance_data' ... etc - how would this be done?
Thank you.
Adam Danz
Adam Danz 2018-8-17
编辑：Adam Danz 2018-8-17
You could do it the same way you did with the velocity_data. You could do that in a loop and write each variable to a new sheet... something like this
Not tested
exportVars = {'velocity_data', 'force_data', 'distance_data'};
for i = 1:length(exportvars)
evalString = sprintf('''xlswrite(''Vehicle_Data'', %s, %s, ''A1''', exportVars{i}, sprintf('''Sheet %d''', i))
myVar = evalin('base', evalString);
end
Craig Saunders
Craig Saunders 2018-8-17
Excellent, just what I needed - thank you!

请先登录，再进行评论。

更多回答（0 个）

类别

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

产品

版本

R2016a

标签

Community Treasure Hunt

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

Start Hunting!

Translated by