arrange the values in an array

1 次查看（过去 30 天）
Hassan
Hassan 2011-4-29
I have an array A(80 rows and 5 columns). I want to export it as a table to microsoft word as the values in A (i:i+4,j)are placed in one cell with no cell line between them. Not sure if it's possible in Matlab.
  3 个评论
显示 1更早的评论
Hassan
Hassan 2011-4-29
Hi Andrei, I didn't get what you said but
for i=1:5:80
for j=1:5
A(i:i+4,j)
% export it to word and remove the cell line for the above subarray which I dont know how? well, I don't think it's possible in Matlab. Maybe I need to copy A into an Excel's shet and then copy it from Excel to Word, select 5 cells (rows 1:5, column 1) and use Merge Cell option.
% know how
Andrei Bobrov
Andrei Bobrov 2011-4-29
agree or Excel or textfile.txt

请先登录，再进行评论。

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

采纳的回答

Andrei Bobrov
Andrei Bobrov 2011-4-29
in Excel
xlswrite('namexls',cellfun(@(x)num2str(x.'), mat2cell(A,5*ones(size(A,1)/5,1),ones(1,size(A,2))),'UniformOutput' , false),1,'A1');
  1 个评论
Hassan
Hassan 2011-4-29
thanks a lot Andrei, this is the thing I was looking for. however, the values in each cell are arranged horizontally while I want to arrange them vertically. I sthere any way to transpose the data in each cell?

请先登录，再进行评论。

更多回答（1 个）

Friedrich
Friedrich 2011-4-29
Or you can use Word as Com Server. I prepared a little example for you:
e = actxserver('Word.Application')
e.visible = 1
doc = e.newDocument.Application.Documents.Add
doc.Content.InsertAfter('text')
  1 个评论
Hassan
Hassan 2011-4-29
thanks Friedrich. It's a good example to see how can have access to Word from Matlab.

请先登录，再进行评论。

类别

在 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