Remove the header from multiple text files

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:

Answer 1

[Star Strider]

Consider using xlsread. It will separate the numeric values from the headers. You can still have access to the headers (and other non-numeric data) as well as the raw data by requesting 2 or 3 outputs from xlsread instead of only the first output.

[Majid Mohamod]

Please, Could you explain more in this regard. I still beginner in Matlab!

[Star Strider]

I would do something like this:

[numeric_data, string_data, raw_output] = xlsread('YourFileName.xls');

The ‘numeric_data’ array will have your numeric data (possibly with NaN values in the first row that you can easily eliminate) as a double array. The headers (and other string data) will be in the ‘string_data’ output, and the entire contents of the file (as a cell array) will be in the ‘raw_output’ variable.

See if that does what you want.