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

3 visualizaciones (últimos 30 días)
Joswin Leslie
Joswin Leslie el 23 de Jul. de 2018
Comentada: Krithika A el 24 de Jul. de 2018
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?

Iniciar sesión para responder a esta pregunta.

Respuestas (1)

Krithika A
Krithika A el 24 de Jul. de 2018
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 comentarios
Walter Roberson
Walter Roberson el 24 de Jul. de 2018
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 el 24 de Jul. de 2018
Oh right. Then sorry Joswin, I'm not going to be useful here.

Iniciar sesión para comentar.

Categorías

Más información sobre Spreadsheets en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by