Overwrite data Excel in matlab

조회 수: 36 (최근 30일)
joni nababan
joni nababan 2020년 3월 9일
답변: Image Analyst 2020년 3월 9일
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
darova
darova 2020년 3월 9일
These lines are similar
Can't you just change xlswrite as xlsread?

댓글을 달려면 로그인하십시오.

채택된 답변

Image Analyst
Image Analyst 2020년 3월 9일
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개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by