Write 10 excel for loop

Question

Jason 2016-3-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/271404-write-10-excel-for-loop

评论： Jason 2016-3-4

采纳的回答： Walter Roberson

在 MATLAB Online 中打开

Now I have one original.xlsx, I want to write Data in Sheet1 from E1.

xlswrite('Original.xlsx',Data,'Sheet1','E1')

How do I write 10 different Data{#} into Original.xlsx as different excel name, all in Sheet1 from E1.

for i=1:10
  xlswrite('Original.xlsx',Data{i},'Sheet1','E1')?

2 个评论
显示无隐藏无

Walter Roberson 2016-3-4

To confirm, you want to produce just one output file, right? Do you want the ten in different sheets, or do you want them to go into E1 then E2 then E3 and so on? Or do you want the first to start at E1 and then the second to be in E but below where-ever the first finished? Or ...?

Jason 2016-3-4

I want to have 10 different output excel file. e.g., first one save as 'January.xlsx', second on save as 'February.xlsx', ... All go into E1. Thank you in advance.

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2016-3-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/271404-write-10-excel-for-loop#answer_212327

在 MATLAB Online 中打开

filenames = {'January.xlsx', 'February.xlsx', 'Cheezburger.xlsx', 'Durango95.xlsx', 'EschewObfuscation.xlsx', ....};
for i=1:10
  xlswrite(filenames{i}, Data{i}, 'Sheet1','E1');
end

3 个评论
显示 1更早的评论隐藏 1更早的评论

Walter Roberson 2016-3-4

在 MATLAB Online 中打开

I am not sure what you mean; perhaps you mean something like,

filenames = {'January.xlsx', 'February.xlsx', 'Cheezburger.xlsx', 'Durango95.xlsx', 'EschewObfuscation.xlsx', ....};
[~, ~, orig_raw] = xlsread('Original.xlsx', 'Sheet1');
for i=1:10
  xlswrite(filenames{i}, orig_raw, 'Sheet1');
  xlswrite(filenames{i}, Data{i}, 'Sheet1','E1');
end

However if you were going to do that then I would use

filenames = {'January.xlsx', 'February.xlsx', 'Cheezburger.xlsx', 'Durango95.xlsx', 'EschewObfuscation.xlsx', ....};
[~, ~, orig_raw] = xlsread('Original.xlsx', 'Sheet1');
for i=1:10
  outdata = orig_raw;
  new_data = Data{i};
  outdata(1:length(new_data),5) = new_data;
  xlswrite(filenames{i}, outdata, 'Sheet1');
end

Note: if Data{i} a numeric vector then you would use

for i=1:10
  outdata = orig_raw;
  new_data = num2cell(Data{i});
  outdata(1:length(new_data),5) = new_data;
  xlswrite(filenames{i}, outdata, 'Sheet1');
end

But if Data{i} is a numeric scalar or string then you would use

for i=1:10
  outdata = orig_raw;
  new_data = Data{i};
  outdata{1,5} = new_data;
  xlswrite(filenames{i}, outdata, 'Sheet1');
end

Jason 2016-3-4

I think you answered my questions. I will check the code after I finished the Friday party. Thank you in advance

请先登录，再进行评论。

Answer 2

Joachim Schlosser 2016-3-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/271404-write-10-excel-for-loop#answer_212244

You can write the whole cell array at once. See the cell array example in the online help: http://www.mathworks.com/help/releases/R2015b/matlab/ref/xlswrite.html

If you are asking about the for loop because you first are calculating each cell before writing, I'd advise to export to Excel in a separate step after the loop for performance reasons.