How can remove Excel column by MATLAB

33 次查看（过去 30 天）

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

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?

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

R2019b

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

Translated by