export to excel

6 次查看（过去 30 天）
James
James 2011-8-4
评论： Darina 2014-2-17
Hi
I have several variables which are 2x20 structures.
I want to capture and store all the values in the 2nd row and put this into excel.
How can I do this?

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

回答（3 个）

Fangjun Jiang
Fangjun Jiang 2011-8-4
You may need to use struct2cell() to convert your structure to cell array and then use xlswrite(). Please give an example of your structure. There might be special things to deal with.
James
James 2011-8-4
Okay. I hope this helps. I dont know how else to describe it. For example:
For my 2x20 structured variable called 'variable1'. When I open this in the variable editor, it shows 1x1 structures in every cell.
When double clicking on a cell in the first row this shows: field: cdata value: double
When double clicking on a cell in the second row this shows: field: cdata value: 50 (or some integer number)
Fangjun Jiang
Fangjun Jiang 2011-8-4
Okay, sounds like not a difficult data structure. Take a look at the example I made up, if similar, you can go ahead. This way, the data written to the Excel file keeps the shape of your structure,i.e. 2 rows 20 columns in your case.
NewVariable1=struct('cdata',repmat({50},2,2))
xlswrite('test.xls',reshape([NewVariable1.cdata],size(NewVariable1)))
  3 个评论
显示 1更早的评论
Fangjun Jiang
Fangjun Jiang 2011-8-4
I am saying, you can open NewVariable1 in the variable editor, if it looks similar to what you saw on variable1 (except the size), then you can use my code to write to Excel file. Of course, you need to replace "NewVariable1" with "variable1" in the code. I was careful not to over-write the value of your "variable1".
Darina
Darina 2014-2-17
I have similar problem but it seems that my nested strucutre is also quite difficult to import to excel. I would like to import all the data from the last field 'flowArray' (which is of type double) into excel sheet?
My nested stucture looks like this:
currentFlowArray=allFileMin(i).demand_pattern1.Wm.total.flowArray;

请先登录，再进行评论。

类别

在 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