I have data in excel sheet with two columns and I want to create a third column in place of the first one.
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Sameer Raja
le 29 Oct 2018
Réponse apportée : Kathleen T. Nevola
le 30 Oct 2018
Hi all, I have data in excel sheet with two quantities Force [1st column] and Angle[2nd column]. I want to create a Time stamp using for loop in first column moving force to 2nd column and angle to 3rd, without changing their values.
1 commentaire
dpb
le 30 Oct 2018
HINT: No for loop needed to do this; use colon operator or linspace. datetime may be of interest.
Réponse acceptée
Kathleen T. Nevola
le 30 Oct 2018
You could use the for loop to make a vector of time stamp values and then concatenate the timestamp vector with the force and angle matrix to get a new matrix to export to excel.
mat = [Force Angle]
new_mat = [Time_stamp mat]
Assuming the vectors have the same length.
For more on writing data to excel check out this link: https://www.mathworks.com/help/matlab/import_export/exporting-to-excel-spreadsheets.html
0 commentaires
Plus de réponses (0)
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!