MATLAB Answers

export to excel

64 views (last 30 days)
James
James on 4 Aug 2011
Commented: Darina on 17 Feb 2014
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?

  0 Comments

Sign in to comment.

Answers (3)

Fangjun Jiang
Fangjun Jiang on 4 Aug 2011
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.

  0 Comments

Sign in to comment.


James
James on 4 Aug 2011
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)

  0 Comments

Sign in to comment.


Fangjun Jiang
Fangjun Jiang on 4 Aug 2011
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 Comments

James
James on 4 Aug 2011
how does this work - as it does not point to the original variable "variable1"
Fangjun Jiang
Fangjun Jiang on 4 Aug 2011
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 on 17 Feb 2014
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;

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!