Import and export excel files

3 次查看（过去 30 天）
Cheeesepondue
Cheeesepondue 2018-12-29
编辑： per isakson 2018-12-29
Hello everyone,
I am trying to collect data of column "C" from each excel file and export the data into an excel file using for loop function.
When I open up the exported file "Load_of_samples", All data are the same as the column of the "first" excel file. (column A is the data from the first excel file, and the rest of columns (B~D) are the same as column A.
I am wondering what I did wrong.
Thank you.
XLfile = dir('*.csv');
number_of_files = length(XLfile);
OutputFileName = 'Load_of_samples';
for i = 1:number_of_files
filename = XLfile(i).name;
for i = 1:number_of_files
A(:,i) = xlsread(filename,1,'C:C');
end
xlswrite(OutputFileName,A);
end

请先登录，再回答此问题。

回答（1 个）

madhan ravi
madhan ravi 2018-12-29
  4 个评论
显示 2更早的评论
madhan ravi
madhan ravi 2018-12-29
Thank you sir Walter :-)
Cheeesepondue
Cheeesepondue 2018-12-29
@Water Roberson The problem was the length of rows was different for each excel files.. So now I need to work on that.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by