How do I write strings and numbers to a excel file

19 views (last 30 days)
Anush Lingamoorthy
Anush Lingamoorthy on 12 Jul 2017
Edited: Jan on 12 Jul 2017
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

Answers (1)

Jan
Jan on 12 Jul 2017
Edited: Jan on 12 Jul 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:

Products

Community Treasure Hunt

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

Start Hunting!

Translated by