필터 지우기
필터 지우기

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 CenterFile 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