Joining two columns and exporting to excel
6 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Adnan Jayyousi
le 25 Juin 2022
Modifié(e) : Abderrahim. B
le 25 Juin 2022
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 commentaires
Réponse acceptée
Plus de réponses (2)
Abderrahim. B
le 25 Juin 2022
Modifié(e) : Abderrahim. B
le 25 Juin 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 commentaires
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!