MATLAB Answers

How can remove Excel column by MATLAB

28 views (last 30 days)
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 ?


Sign in to comment.

Accepted Answer

Bob Nbob
Bob Nbob on 5 Dec 2019
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 Comment

prasanth vemula
prasanth vemula on 18 Jun 2020
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?

Sign in to comment.

More Answers (0)