How to write a vector to excel?

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

Categorie

Scopri di più su Data Import from MATLAB in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by