Open Excel file read name of data file, process data file write to six different excel output data files, Repeat in a for loop

32 次查看（过去 30 天）
Branko Celler
Branko Celler 2025-12-9，11:35
回答： dpb 2025-12-9，13:19
for i=1:30
open excel INPUT file
read data fle names from Excel INPUT file
% internal loop
for j=1:6
process data
open one excel OUTPUT file
write results to excel file as a cell array along one row of excel output file
save excel file
close excel file
end
end
have tried multiple methods, all of which failed, maybe not appropriate to MATLAB R2020b?

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

采纳的回答

dpb
dpb 2025-12-9，13:19
for i=1:30
open excel INPUT file
read data fle names from Excel INPUT file
% internal loop
for j=1:6
%process data
C=yourprocessingfunctionthatreturnscellarray();
open one excel OUTPUT file
%write results to excel file as a cell array along one row of excel output file
writecell(C,outputfile(j))
end
end
As in the other Answer, you're trying to do too much here -- writecell and friends handle the opening and the closing internally including creating the new file from the given file name.
As @Mathieu NOE noted, showing an example file always makes easier for folks to make specific code, as well as having actual code to be able to comment on.

更多回答（0 个）

类别

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

标签

产品


版本

R2022b

Community Treasure Hunt

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

Start Hunting!

Translated by