I have data in excel sheet with two columns and I want to create a third column in place of the first one.

Question

Sameer Raja 2018-10-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/426808-i-have-data-in-excel-sheet-with-two-columns-and-i-want-to-create-a-third-column-in-place-of-the-firs

回答： Kathleen T. Nevola 2018-10-30

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

dpb 2018-10-30

HINT: No for loop needed to do this; use colon operator or linspace. datetime may be of interest.

请先登录，再进行评论。

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

Answer 1

Kathleen T. Nevola 2018-10-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/426808-i-have-data-in-excel-sheet-with-two-columns-and-i-want-to-create-a-third-column-in-place-of-the-firs#answer_344077

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