I have data in excel sheet with two columns and I want to create a third column in place of the first one.
2 views (last 30 days)
Show older comments
Sameer Raja
on 29 Oct 2018
Answered: Kathleen T. Nevola
on 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 Comment
dpb
on 30 Oct 2018
HINT: No for loop needed to do this; use colon operator or linspace. datetime may be of interest.
Accepted Answer
Kathleen T. Nevola
on 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 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets 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!