How to write a vector to excel?

60 vues (au cours des 30 derniers jours)
Khanh
Khanh le 4 Oct 2014
Commenté : Khanh le 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.

Réponse acceptée

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

Connectez-vous pour commenter.

Plus de réponses (0)

Community Treasure Hunt

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

Start Hunting!

Translated by