How to write names of txt files on top cell of each calculated column in an excel file?

4 次查看（过去 30 天）

显示更早的评论

Aramis 2022-3-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1663154-how-to-write-names-of-txt-files-on-top-cell-of-each-calculated-column-in-an-excel-file

评论： Aramis 2022-3-9

采纳的回答： Walter Roberson

在 MATLAB Online 中打开

Hi all,

I have a folder with several txt files in it.

My calculating code runs perfect and the final outcome is an excel file with columns of data for each file, as below:

filenameList = dir('C:\Users\myself\Desktop\test\*.txt');
finalArray = [];
for filenameIndex = 1:length(filenameList)
    filename = [filenameList(filenameIndex).folder '\' filenameList(filenameIndex).name];
    inData = importdata(filename,'\t',8);
    inData = inData.data;
    outArray = Calc1(inData);
    outArray2 = Calc2(outArray);
    finalArray = [finalArray outArray2];
    
end
filename = xlswrite('output.xlsx',finalArray);

How can I tweak it to add the file names on the top cell of each column (each column represnt the calculated data for each txt files) of the excel file?

thanks