清空筛选条件
清空筛选条件

How to import excel data

2 次查看（过去 30 天）
anush
anush 2017-5-31
回答： KSSV 2017-5-31
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

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

回答（1 个）

KSSV
KSSV 2017-5-31
a = xlsread('frequency.xlsm','Data','range')
save('myfile.mat','a')

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by