How to write a vector to excel?

12 次查看（过去 30 天）
Khanh
Khanh 2014-10-4
评论： Khanh 2014-10-4
Hi,
I have an array like this: a=0:100:500
I want to write its each element to each cell of excel.
I know to do it the array has to become as a'=[0,100,200,300,400,500];
But how I can get the array a' which created by adding comma.
Any help would be greatly appreciated.
Thanks.

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

采纳的回答

Image Analyst
Image Analyst 2014-10-4
I don't understand the comma stuff you said, and don't know why you have an apostrophe like you want to transpose a or something. But to write a vector to Excel and have it look like what you showed, use:
xlswrite(fullFileName, a, 'D23');
  2 个评论
Khanh
Khanh 2014-10-4
Thanks. You're right. I'm just a little bit silly.
Khanh
Khanh 2014-10-4
Apostrophe a (a') is just a name I give to a new array. Sorry, I should name it correctly.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by