How can remove Excel column by MATLAB

2019 12 5
1 个回答
回答已采纳
更新时间：2020 6 18
5 次查看（30 天）

0 个投票

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
Bob Thompson 2019-12-5

0 个投票

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 个评论
显示 -1更早的评论 隐藏 -1更早的评论

prasanth vemula
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?

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

版本

R2019b

标签

Community Treasure Hunt

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

Start Hunting!

Translated by