How to write a vector to excel?

57 views (last 30 days)
Khanh
Khanh on 4 Oct 2014
Commented: Khanh on 4 Oct 2014
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.

Accepted Answer

Image Analyst
Image Analyst on 4 Oct 2014
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 Comments
Khanh
Khanh on 4 Oct 2014
Thanks. You're right. I'm just a little bit silly.
Khanh
Khanh on 4 Oct 2014
Apostrophe a (a') is just a name I give to a new array. Sorry, I should name it correctly.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!