Hi all..
I use the following code to export multiple columns in excel file to multiple text files (each column export as text file).
Walter Roberson wrote me the following code:
data = readtable('YourFileName.xls');varnames = data.Properties.VariableNames;for col = 1 : size(data, 2) thisvar = varnames{col}; filename = sprintf('split_%s.txt', thisvar); writetable( data(:,col), filename );end
It works very well, but the only problem is each text file gets a header X1. Can I use this script without having header? The following screenshot explain more about the problem:
Best Answer