How to import excel data
2 views (last 30 days)
Show older comments
Hallo, I am using matlab Gui. I have a pushbutton_callback which should be able to store my data into workspace reading it from '.xls' file. I don't want to use the import tool rather i would like to click and get the data in workspace. I am able to read from xlsread but when i save, it is saved in .mat. Please help!! My code is :
function pushbutton17_Callback(hObject, eventdata, handles)
% hObject handle to pushbutton17 (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
a = xlsread('frequency.xlsm','Data','range') %%%How can i have a range from 'A7:A23','C7:F23' ??
save('a'); %%saves in .mat instead in workspace .dat
0 Comments
Answers (1)
See Also
Categories
Find more on Data Import and Analysis in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!