How can remove Excel column by MATLAB

25 ビュー (過去 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