How can remove Excel column by MATLAB

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]

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]

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?