Displaying array in a cell

Question

Alex 2013-4-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/73614-displaying-array-in-a-cell

I have described three double arrays and I am trying to create a table that I can then write to excel using xlswrite. I define my table, but I want the double arrays to show up in the table as columns of data when I write to excel. here is my code

Table = {'GrayShade', 'Digital Units', 'LE Night 50%'; grayShade digUnits stepsN50L};
xlswrite('Gamma Stability.xlsx',Table,'Gray Shade Table','B2');

assume grayShade, digUnits, and stepsN50L are all good double arrays with data in them...because they are. No problem there. When I use the above code, the cell table only has the column titles in it and instead of having a column of data, a single cell underneath each title says double and it does not columnate the data. How do I do this?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Alex 2013-4-25

Well I meant for it to say "17x1" everywhere that it currently says double

请先登录，再进行评论。

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

Answer 1

Image Analyst 2013-4-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/73614-displaying-array-in-a-cell#answer_83530

You need to put each number from the array into its own cell. So if those arrays are 10 rows by 5 columns, you'll need a 11 row by 15 column cell array. Put the strings into the first row. If you want an empty cell, you still need to put in []. Then loop over the arrays putting one number into each cell until you have all cells from row 2 down through row 11 filled in with your arrays. Then write that cell to Excel. If you don't understand, give your array dimensions and I could write up a little demo.

2 个评论
显示无隐藏无

Alex 2013-4-25

I do not understand entirely...all the arrays are 17 rows by 1 column. Are you saying I have to write a for loop to write in every individual entry from the array into the cell one by one?

Cedric 2013-4-26

编辑：Cedric 2013-4-26

在 MATLAB Online 中打开

Image Analyst's answer suggests the following:

 header = {'GrayShade', 'Digital Units', 'LE Night 50%'} ;
 data   = mat2cell([grayShade, digUnits, stepsN50L]) ;   
 Table  = [header; data] ;

This assumes that all your numeric arrays are column vectors. If you don't want to care about their shape, you can replace the second line with:

data = mat2cell([grayShade(:), digUnits(:), stepsN50L(:)]) ;

There is no FOR loop; MAT2CELL does the trick. If you look at data, you'll see that it is a cell array, and that each cell contains a single number. In your first attempt, you were passing a 2 x 3 cell array to XLSWRITE, which was trying to store the content of e.g. cell Table(2,1) [which was the whole array grayShade] into a single Excel cell.

请先登录，再进行评论。