Joining two columns and exporting to excel

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

Answer 1

[Amritesh]

1. To merge two arrays into one table

newTable = table(A,B);

2. To export newTable as .xlsx file

writetable(newTable,'newTable.xlsx');

Hope this solves your problem.

Answer 2

[Jonas]

use mat2cell before joining them!

[mat2cell(A) mat2cell(B)]

Answer 3

[Abderrahim. B]

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.

1. Create a table and populate it with your 2 arrays
2. 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!