how to write certain rows in excel using xlswrite

Question

live to l e a r n MATLAB 2012-10-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/49980-how-to-write-certain-rows-in-excel-using-xlswrite

This is my values A:1 4 2 5 3 6 8 7 9 10 1 2 11 13 14 15 and

 for i=1:1:16
   xlswrite('filename.xlsx',A)

end

and here my excel sheet having one values only:15

but am needed 1 4 2 5 3 6 8 7 9 10 1 2 11 13 14 15

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

live to l e a r n MATLAB 2012-10-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/49980-how-to-write-certain-rows-in-excel-using-xlswrite#answer_61016

nothing happened

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Muruganandham Subramanian 2012-10-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/49980-how-to-write-certain-rows-in-excel-using-xlswrite#answer_61014

在 MATLAB Online 中打开

Hi kesavan,

Insteadof writing it as 'filename.xlsx' .try it as 'filename.xls'

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 3

Image Analyst 2012-10-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/49980-how-to-write-certain-rows-in-excel-using-xlswrite#answer_61020

在 MATLAB Online 中打开

Does that mean your question is figured out? I mean, you just wrote the same array of 15 numbers out to the same workbook/worksheet 16 times in a row, so what were you expecting?

Or maybe A is just a scalar, not an array and you wanted each element in a different row. Like this:

for k = 1 : 16
   cellReference = sprintf('A%d', k);
   xlswrite('filename.xlsx', A(k), cellReference)
end

But you don't want to use xlswrite that many times unless you're willing to have it be very slow because it has to launch and shutdown Excel every iteration in your loop. You'd want to use xlswrite1 (File Exchange) and ActiveX programming.