フィルターのクリア

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 ExchangeData Import and Analysis についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by