How to write names of txt files on top cell of each calculated column in an excel file?
조회 수: 2 (최근 30일)
이전 댓글 표시
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
댓글 수: 0
채택된 답변
Walter Roberson
2022년 3월 3일
array2table with the 'variablenames' option, and writetable() instead of xlswrite
댓글 수: 10
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!