Hello,
Please Help me. I want to overwrite the data in Excel with matlab where the data I entered there are 2 columns and I want to overwrite the column 2 with new data from uitable
Can you help me?
Here's the code :
load_button :
function loadbutton_Callback(hObject, eventdata, handles) [filename,path] = uigetfile('.xlsx') dataExcel = xlsread(fullfile(path,filename),'sheet1','E2:F50')
save_button:
function savebutton_Callback(hObject, eventdata, handles)[excelName,excelPath] = uiputfile('*.xlsx')title = {'Fuzzy'}data = get(handles.uitable1, 'data');fdata = data(:,3);sheet = 1x1Range = 'A1'xlswrite([excelPath excelName],fdata,sheet,x1Range)
Please help me
Best Answer