How do I write strings and numbers to a excel file
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
I am trying to create a .csv or .xlsx file with data and strings. The first row being titles Example output:
Test# Subject Data1 Data2 Data3
Test1 AAA 1 2 3
Test2 BBB 4 5 6
I made a matrix that stores the data in a variable A. Using csvwrite('Temp',A)
A=[1 2 3;4 5 6]
csv file output:
1 2 3
4 5 6
But am unable to add the titles which are stored as strings
0 comentarios
Respuestas (1)
Jan
el 12 de Jul. de 2017
Editada: Jan
el 12 de Jul. de 2017
Data = {'Test#', 'Subject', 'Data1', 'Data2', 'Data3'; ...
'Test1', 'AAA', 1, 2, 3; ...
'Test2', 'BBB', 4, 5, 6};
xlswrite('File.xlsx', A);
You find some implementations to store a cell in a CSV file directly in the FileExchange:
0 comentarios
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!