您正在关注此问题

您将在关注的内容源中看到更新。
您可能会收到电子邮件，具体取决于您的通信预设项。

Writing multiple structures to user specified excel file

1 次查看（过去 30 天）

显示更早的评论

Ibro Tutic 2016-4-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file

⋮

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file

评论： Ibro Tutic 2016-4-5

采纳的回答： Azzi Abdelmalek

I have a variable amount of structures with 4 fields, each containing 1x1 blocks of data. How would I go about writing multiple structures to a user specified excel file?

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356183

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356183

Can you give an example?

Ibro Tutic 2016-4-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356187

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356187

Sure, they look like this, in general.

请先登录，再进行评论。

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

采纳的回答

Azzi Abdelmalek 2016-4-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#answer_216569

⋮

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#answer_216569

编辑：Azzi Abdelmalek 2016-4-5

在 MATLAB Online 中打开

load Example
v=[struct2cell(Data1.data)]
out=v(:,:)'
xlswrite('file.xlsx',out)

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356195

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356195

What if I have multiple structures to consider? Essentially the program allows calculations to be ran against user specified mat files that contain damage information, for each file they select, another structure is created. What I need it for every structure to be outputted to the same, user-specified excel file.

Azzi Abdelmalek 2016-4-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356198

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356198

You need to provide more details, how many fields for each data? do you want to store the data in different sheets?

Ibro Tutic 2016-4-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356200

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356200

The data is exactly the same as that example, but instead of being 10x4, it might be 200x4, or 150x4, but the heading and everything is exactly the same. The data does not need to be stored in different sheets. Also, the PINs are unique, not in numerical order like I had put in the example (not sure if it's confidential information or not). Just imagine having n structures within one structure, with data corresponding to PIN, Displacement, Damage, and hours in each of the structures.

Azzi Abdelmalek 2016-4-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356201

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356201

Ok, your data are in one mat file or in different mat files?

Ibro Tutic 2016-4-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356203

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356203

Well, the data is created within the program and stored as a variable, so it is all in one file.

Azzi Abdelmalek 2016-4-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356209

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356209

You have to make things clear. all your variables are stored in one mat file? do you mean that you are creating several variables with different names? If it's in the program, can you show us the part of your program that are creating these variables, because it's a bad idea to create different variables names, when you can store all your data in one variable

Ibro Tutic 2016-4-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356213

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356213

在 MATLAB Online 中打开

The code is below. The program reads a mat file, copies the data to a structure, reads another mat file, copies similar data to another structure, and so on.

Essentially, if the user selects two mat files to be processed, two structures would be created. I then need these two structures to be exported to an excel spreadsheet, the same spreadsheet, on the same page.

filepath1 = 'C:\Users\it58528\Desktop\13.5 Stuff\13.5 Mat Files\'; 
filename = uigetfile('*.*',  'All Files (*.*)','MultiSelect','on');
for n=1:length(filename)
    data1{n} = load([filepath1 filename{n}]);
end
for i=1:length(data1)
    for j=1:length(data1{i}.PIN)
        Data(i).data(j).PIN = data1{i}.PIN(j).PIN;
        Data(i).data(j).hours = data1{i}.PIN(j).hours;
        Data(i).data(j).Disp = data1{i}.PIN(j).Displacement;
        Data(i).data(j).damage = sum(sum((data1{i}.PIN(j).LoadProfilePercent.*DamagenewTable),1));
    end
end

Azzi Abdelmalek 2016-4-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356214

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356214

编辑：Azzi Abdelmalek 2016-4-5

在 MATLAB Online 中打开

filename = uigetfile('*.*',  'All Files (*.*)','MultiSelect','on');
for n=1:length(filename)
  data1{n} = load(filename{n});
end
out=[];
for i=1:length(data1)
   v=[struct2cell(data1{i}.Data1.data)]
  out=[out;v(:,:)']
end
xlswrite('file.xlsx',out)

Ibro Tutic 2016-4-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356216

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356216

That works, but it seems to be overwriting previous entries, how would I get around that?

Azzi Abdelmalek 2016-4-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356217

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356217

What do you mean?

Azzi Abdelmalek 2016-4-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356220

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356220

maybe you have used my code before editing it. copy it now and try again

Ibro Tutic 2016-4-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356221

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356221

在 MATLAB Online 中打开

Well, here is the code I adapted from yours.

for i=1:length(data1)
   v=[struct2cell(Data(i).data)];
   out=[v(:,:)'];
end

So what it does is it goes through the structure Data(1).data, converts it to a cell array, cleans up the formatting, and is stored in the variable 'out'. Now when it moves on to the second part of the structure, Data(2).data, the data from the first structure (Data(1).data) are overwritten, leaving only data from Data(2).data in the cell array. What I need is for them both to be in the same table.

Azzi Abdelmalek 2016-4-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356222

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356222

在 MATLAB Online 中打开

This is not my code, What I've posted is:

out=[];
for i=1:length(data1)
 v=[struct2cell(data1{i}.Data1.data)]
out=[out;v(:,:)']
end

Ibro Tutic 2016-4-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356223

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356223

Your code attempts to access a non-existent structure, I simply modified it so it does what I need it to do. The issue is still the same, the data from one structure is getting over written, but I need all the data to be in a single variable, 'out'.

Azzi Abdelmalek 2016-4-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356226

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356226

post your modified code

Ibro Tutic 2016-4-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356228

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356228

在 MATLAB Online 中打开

filepath1 = 'C:\Users\it58528\Desktop\13.5 Stuff\13.5 Mat Files\'; 
filename = uigetfile('*.*',  'All Files (*.*)','MultiSelect','on');
for n=1:length(filename)
    data1{n} = load([filepath1 filename{n}]);
end
for i=1:length(data1)
    for j=1:length(data1{i}.PIN)
        Data(i).data(j).PIN = data1{i}.PIN(j).PIN;
        Data(i).data(j).hours = data1{i}.PIN(j).hours;
        Data(i).data(j).Disp = data1{i}.PIN(j).Displacement;
        Data(i).data(j).damage = sum(sum((data1{i}.PIN(j).LoadProfilePercent.*DamagenewTable),1));
    end
end
for i=1:length(data1)
   v=[struct2cell(Data(i).data)];
   out=[v(:,:)'];
end

Azzi Abdelmalek 2016-4-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356231

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356231

在 MATLAB Online 中打开

You did not look at my code!

out=[]
for i=1:length(data1)
 v=[struct2cell(Data(i).data)];
 out=[out;v(:,:)'];
end

Ibro Tutic 2016-4-5

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356234

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/277305-writing-multiple-structures-to-user-specified-excel-file#comment_356234

Oh that worked! Thank you!

请先登录，再进行评论。

另请参阅

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

Community Treasure Hunt

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

Start Hunting!

发生错误

由于页面发生更改，无法完成操作。请重新加载页面以查看其更新后的状态。

Translated by

选择网站

选择网站以获取翻译的可用内容，以及查看当地活动和优惠。根据您的位置，我们建议您选择：。

(English)
(Deutsch)
(Français)

（简体中文）
(English)

您也可以从以下列表中选择网站：

如何获得最佳网站性能

选择中国网站（中文或英文）以获得最佳网站性能。其他 MathWorks 国家/地区网站并未针对您所在位置的访问进行优化。

美洲

América Latina (Español)
Canada (English)
United States (English)

欧洲

Belgium (English)
Denmark (English)
Deutschland (Deutsch)
España (Español)
Finland (English)
France (Français)
Ireland (English)
Italia (Italiano)
Luxembourg (English)

Netherlands (English)
Norway (English)
Österreich (Deutsch)
Portugal (English)
Sweden (English)
Switzerland
United Kingdom(English)

亚太

Australia (English)
India (English)
New Zealand (English)
中国
- 简体中文Chinese
- English
日本Japanese (日本語)
한국Korean (한국어)

联系您当地的办事处

Writing multiple structures to user specified excel file

2 个评论
显示无隐藏无

采纳的回答

18 个评论
显示 16更早的评论隐藏 16更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

Writing multiple structures to user specified excel file

2 个评论 显示 无隐藏 无

采纳的回答

18 个评论 显示 16更早的评论隐藏 16更早的评论

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

2 个评论
显示无隐藏无

18 个评论
显示 16更早的评论隐藏 16更早的评论