
Overwrite data Excel in matlab
28 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
joni nababan
le 9 Mar 2020
Réponse apportée : Image Analyst
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
Réponse acceptée
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);
0 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!