How can remove Excel column by MATLAB

24 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 ?
regards

Accepted Answer

Bob Thompson
Bob Thompson 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)

Tags

Products


Release

R2019b

Community Treasure Hunt

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

Start Hunting!