GUIDE GUI export data to Excel

4 次查看（过去 30 天）
Craig Saunders
Craig Saunders 2018-8-17
编辑： Adam Danz 2018-8-17
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 个评论
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
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更早的评论
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品


版本

R2016a

Community Treasure Hunt

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

Start Hunting!

Translated by