How do I convert my .asc file to .xlsx file using MATLAB?

I have around three lines of words in my "PLC1.asc" file and then data (around 9000 rows and 3 columns) from my measurements. I want to convert this data to excel using MATLAB. Can anyone tell me what function to use?

[Walter Roberson]

Do you need to preserve the lines of words in your output file?

Answer 1

[Krithika A]

An example of one file (you'll need to change it depending on your data structure):

file = 'file.dat'; 
delim = ' '; % Your delimiter
data = dlmread(file,'delimiter',delim);
filename_out = 'your_excel.xls';
xlswrite(filename_out,data)

[Walter Roberson]

dlmread() cannot normally handle text, unless it is header lines that you tell it to skip, or it is in leading columns that you tell it to skip.

[Krithika A]

Oh right. Then sorry Joswin, I'm not going to be useful here.