MATLAB Answers

Matrix with strings and numbers

11 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

  0 Comments

Sign in to comment.

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

Show 3 older comments
Walter Roberson
Walter Roberson on 11 May 2020
I am not seeing any change in the format of the date column; I opened the file in excel to confirm that it is considered a text field there. When I readtable() it back in, it still knows it as text.
Note: I am not using Windows with Excel installed, so my system would not be talking to Excel to do the writing.
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
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.

Community Treasure Hunt

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

Start Hunting!

Translated by