How to write a vector to excel?

9 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)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!