MATLAB Answers

0

How do I write strings and numbers to a excel file

Asked by Anush Lingamoorthy on 12 Jul 2017
Latest activity Edited by 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

  0 Comments

Sign in to comment.

Products

1 Answer

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

  0 Comments

Sign in to comment.