MATLAB Answers

How can remove Excel column by MATLAB

18 views (last 30 days)
Furat Alobaidy
Furat Alobaidy on 5 Dec 2019
Answered: Bob Nbob on 5 Dec 2019
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

  0 Comments

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

  0 Comments

Sign in to comment.

More Answers (0)

Sign in to answer this question.

Tags

Products


Release

R2019b