How can remove Excel column by MATLAB

Question

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

Answer 1

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

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?