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

9 次查看（过去 30 天）
Joswin Leslie
Joswin Leslie 2018-7-23
评论： Krithika A 2018-7-24
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?

请先登录，再回答此问题。

回答（1 个）

Krithika A
Krithika A 2018-7-24
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)
  2 个评论
Walter Roberson
Walter Roberson 2018-7-24
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
Krithika A 2018-7-24
Oh right. Then sorry Joswin, I'm not going to be useful here.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by