How to write a vector to excel?

54 visualizzazioni (ultimi 30 giorni)
Khanh
Khanh il 4 Ott 2014
Commentato: Khanh il 4 Ott 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.

Risposta accettata

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

Accedi per commentare.

Più risposte (0)

Community Treasure Hunt

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

Start Hunting!

Translated by