How to insert a row into multiple fields (within a structure)

2018 7 16
3 个回答
回答已采纳
更新时间：2018 7 17
14 次查看（30 天）

0 个投票

Hi All,
My code looks as follows:
clear all;
close all;
clc
[~, Sheets] = xlsfinfo('GPSdata2018copy.xlsx');
nSheets = length(Sheets);
Data =[]
GPS = struct
for i = 1:nSheets
Player = Sheets{i};
[Data,~,Raw] = xlsread('GPSdata2018copy.xlsx', Player, 'E8:KE16');
Dates = datetime(Data(1,:),'convertfrom','excel');
Data(1,:) = datenum(Dates);
GPS = setfield(GPS, Player, Data);
end
I want to add a row to each of my fields in the second row under the dates without removing any of the data that is in there (just moving the data down). Can someone please tell me how to do that? Do I do it in the loop, our have to do it to the Data that I read over?
Kind regards, Mat

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

 采纳的回答

0 个投票

Mat,
I've created dummy data that from what you're saying is similar in structure to what you use.
The result of the code ends up like this:
You want to add a single row to the top of the field value array?
If so it can be done in the loop using something like this:
Dates = datetime(Data(1,:),'convertfrom','excel');
Data(1,:) = datenum(Dates);
Data = [Data(1, :); zeros(1, size(Data, 2)); Data(2:end, :)];
GPS = setfield(GPS, Player, Data);

更多回答（2 个）

Mathew Grey
Mathew Grey 2018-7-16

0 个投票

Hi Christopher,
Thanks for the reply. I am really sorry but unfortunately the data file contains confidential information that I cannot release. The above code works for the data and creates a structure with a field for each player. Inside the fields contains a data matrix for each player with the same dimensions (9 x 287). I wish to add a single row to each of the fields (in row 1) that I will fill with an outside formula (that isn't in the data file). Can you please help?

类别

在 帮助中心 和 File Exchange 中查找有关 Structures 的更多信息

产品

版本

R2017b

标签

Community Treasure Hunt

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

Start Hunting!

Translated by