Joining two columns and exporting to excel

4 ビュー (過去 30 日間)
Adnan Jayyousi
Adnan Jayyousi 2022 年 6 月 25 日
編集済み: Abderrahim. B 2022 年 6 月 25 日
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 ?


Amritesh 2022 年 6 月 25 日
編集済み: Amritesh 2022 年 6 月 25 日
1. To merge two arrays into one table
newTable = table(A,B);
2. To export newTable as .xlsx file
Hope this solves your problem.

その他の回答 (2 件)

Jonas 2022 年 6 月 25 日
use mat2cell before joining them!
[mat2cell(A) mat2cell(B)]

Abderrahim. B
Abderrahim. B 2022 年 6 月 25 日
編集済み: Abderrahim. B 2022 年 6 月 25 日
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!


Find more on Tables 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!

Translated by