Joining two columns and exporting to excel
7 views (last 30 days)
Show older comments
Hello,
I have the following arrays, I want to join them into one matrix and export them as .xlsx file.
be mindful thae B is datetime, i tried to do it in the simple way creating a matrix but it gives error, any conversion may be needed here ?
thanks
0 Comments
Accepted Answer
More Answers (2)
Abderrahim. B
on 25 Jun 2022
Edited: Abderrahim. B
on 25 Jun 2022
Hi !
You are trying to concatenate datetime array with an array of data type double that is why you got that error.
- Check this answer maybe it answers your question.
- Here is another way that I propose to export to spreadsheet.
- Create a table and populate it with your 2 arrays
- Use writetimetable to export to excel.
%% Example
% Dummy arrays
dTime = datetime(2013,11,1,8,0,0):datetime(2013,11,20,8,0,0) ;
fArray = 1:20 ;
% Populate the table
concatArrays = timetable(transpose(dTime), transpose(fArray), 'VariableNames',"Number" ) ; % transpose the array if they are row vectors
% Export to excel
writetimetable(concatArrays, 'Concatenated.xlsx')
Hope this solves your issue!
0 Comments
See Also
Categories
Find more on Spreadsheets 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!