How can remove Excel column by MATLAB

조회 수: 52(최근 30일)
Furat Alobaidy
Furat Alobaidy 2019년 12월 5일
댓글: prasanth vemula 2020년 6월 18일
Hi ,
please i have Excel file contains multi coulums how can remove entire specfic coulums ;
for example i have colums (A,B , C) how can remove coulum C ?
regards

채택된 답변

Bob Thompson
Bob Thompson 2019년 12월 5일
The simplest way is to load the excel file with xlsread, then write the data back with only the desired columns using xlswrite.
data = xlsread('Myexcelfile.xlsx');
xlswrite('Myexcelfile_reduced.xlsx',data(:,1:2)); % Only columns A and B
  댓글 수: 1
prasanth vemula
prasanth vemula 2020년 6월 18일
Yah, but if the data to be sent back is smaller than the previous data. It`ll only rewrite a part of it and the remaining will be the previous data.
Is there any other work around?

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

추가 답변(0개)

태그

제품


릴리스

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by