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

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

Answer 1

[Walter Roberson]

array2table with the 'variablenames' option, and writetable() instead of xlswrite

[Aramis]

Thanks for the reply. can you be more specific please? "writetable()" needs a new variable or simply substitue for xlswrite? Also what do you mean by 'variablenames' option?

[Aramis]

Can you help a little more please? I am a beginner and trying to understand step by step. :)

[Walter Roberson]

projectdir = 'C:\Users\myself\Desktop\test';

filenameList = dir( fullfile(projectdir, '*.txt')) ;
num_files = length(filenameList);
fullnames = fullfile({filenameList.folder}, {filenameList.name});
[~, basenames, ~] = fileparts(fullnames);

for filenameIndex = 1:num_files
    filename = fullnames(filenameIndex);
    inData = importdata(filename,'\t',8);
    inData = inData.data;
    outArray = Calc1(inData);
    outArray2 = Calc2(outArray);
    finalArray(:, filenameIndex) = outArray2;    
end

T = array2table(finalArray, 'VariableNames', basenames);

writetable(T, 'output.xlsx');

[Aramis]

I appreciate your answer. I guess I Understand the approach here, but it says an error for "T = array2table(finalArray, 'VariableNames', basenames);"

[Walter Roberson]

please show

whos finalArray basenames

[Aramis]

Here is what i edited, now there is no error but the output is a blank xls file:

projectdir = 'C:\Users\Me\Desktop\test\*.txt';
filenameList = dir( fullfile(projectdir, '*.txt')) ;
finalArray = [];

num_files = length(filenameList);
fullnames = fullfile({filenameList.folder}, {filenameList.name});
[~, basenames, ~] = fileparts(fullnames);

for filenameIndex = 1:num_files
    filename = fullnames(filenameIndex);
    inData = importdata(filename,'\t',8);
    inData = inData.data;
    outArray = Calc1(inData);
    outArray2 = Calc2(outArray);
    finalArray(:, filenameIndex) = outArray2;    
end
T = array2table(finalArray, 'VariableNames', basenames);
writetable(T, 'output.xlsx');

[Walter Roberson]

projectdir = 'C:\Users\Me\Desktop\test';

[Aramis]

Ah! you are right.

Now it has an error for :

Error using importdata

Unable to open file.

Error in Filenames_Export

inData = importdata(filename,'\t',8);

[Walter Roberson]

filename = fullnames{filenameIndex};

[Aramis]

Hey Walter, Thanks for your help. It worked great and the output looks valid.