GUIDE GUI export data to Excel
10 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Craig Saunders
am 17 Aug. 2018
Bearbeitet: Adam Danz
am 17 Aug. 2018
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 Kommentar
Stephen23
am 17 Aug. 2018
Bearbeitet: Stephen23
am 17 Aug. 2018
"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:
Akzeptierte Antwort
Adam Danz
am 17 Aug. 2018
From your bushbutton callback you can evaluate the expression from the base workspace. If you get stuck, follow-up and I can help.
6 Kommentare
Adam Danz
am 17 Aug. 2018
Bearbeitet: Adam Danz
am 17 Aug. 2018
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
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!