Joining two columns and exporting to excel

7 次查看（过去 30 天）
Adnan Jayyousi
Adnan Jayyousi 2022-6-25
编辑： Abderrahim. B 2022-6-25
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

请先登录，再回答此问题。

采纳的回答

Amritesh
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
writetable(newTable,'newTable.xlsx');
Hope this solves your problem.

更多回答（2 个）

Jonas
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!

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by