How to write names of txt files on top cell of each calculated column in an excel file?
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Aramis
am 3 Mär. 2022
Kommentiert: Aramis
am 9 Mär. 2022
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 Kommentare
Akzeptierte Antwort
Walter Roberson
am 3 Mär. 2022
array2table with the 'variablenames' option, and writetable() instead of xlswrite
10 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!