Overwrite data Excel in matlab

48 vues (au cours des 30 derniers jours)
joni nababan
joni nababan le 9 Mar 2020
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 = 1
x1Range = 'A1'
xlswrite([excelPath excelName],fdata,sheet,x1Range)
Please help me
  1 commentaire
darova
darova le 9 Mar 2020
These lines are similar
Can't you just change xlswrite as xlsread?

Connectez-vous pour commenter.

Réponse acceptée

Image Analyst
Image Analyst le 9 Mar 2020
Column 2 is B, not A. So do this:
x1Range = 'B1'; % Column 2 is B not A.
xlFullFileName = fullfile(excelPath, excelName);
xlswrite(excelName, fdata, sheet, x1Range);

Plus de réponses (0)

Community Treasure Hunt

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

Start Hunting!

Translated by