Matrix with strings and numbers

6 views (last 30 days)
ektor
ektor on 10 May 2020
Commented: Ameer Hamza on 11 May 2020
Dear all,
I have a column that contains thousands of the following elements (this is just a sample)
A=[ '2008-12-05 15:59:57'
'2008-12-05 15:59:57'
'2008-12-05 15:59:58'
'2008-12-05 15:59:58'
'2008-12-05 15:59:58'];
and I also have the following matrix that contains thousands of elements (this is just a sample)
B=[39.44 4900
39.44 100
39.44 200
39.44 100
39.44 100];
How can I get a matrix, say C=[A B]; and then save it in an excel?
Is there any code?
Please bear in mind that A and B contain thousands of elements.
Also to create A I used the command datestr(D,31);
Thank you in advance

Answers (2)

Ameer Hamza
Ameer Hamza on 11 May 2020
Edited: Ameer Hamza on 11 May 2020
Normal MATLAB array can only hold data of single type. You need to use cell array. Try something like this
A=[ '2008-12-05 15:59:57'
'2008-12-05 15:59:57'
'2008-12-05 15:59:58'
'2008-12-05 15:59:58'
'2008-12-05 15:59:58'];
B=[39.44 4900
39.44 100
39.44 200
39.44 100
39.44 100];
C = [num2cell(string(A)) num2cell(B)];
writecell(C, 'test.xlsx');
It will work on R2019a and later versions.
  6 Comments
ektor
ektor on 11 May 2020
Hi Walter,
I use Windows with excel. Any other ideas how to solve this issue?
Ameer Hamza
Ameer Hamza on 11 May 2020
ektor, maybe you can try to set the 'UseExcel' option to false (although it should is false by default). Alternatively, you can also experiment by setting it to true
writetable(cell2table(C), 'test.xlsx', 'WriteVariableNames', false, 'UseExcel', false);
and
writetable(cell2table(C), 'test.xlsx', 'WriteVariableNames', false, 'UseExcel', true);
Also, open the MS Excel file and check what datatype the Excel considers this cell to be
01/12/2008 09:30

Sign in to comment.


Steven Lord
Steven Lord on 11 May 2020
I recommend converting A into a datetime array and using that to create a timetable array.
  2 Comments
ektor
ektor on 11 May 2020
Any sample code?
ektor
ektor on 11 May 2020
Edited: ektor on 11 May 2020
I found a way.
I copy directly the C matrix from data editor and I paste it inside an empty excel file.
It works. The only problem is that I get the operators '' '' for the date column
''2008-12-01 09:30:02'' 41.64 3441
Can I remove those within matlab before pasting into excel?

Sign in to comment.

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!