writing an array to excel

I have an array of data (5000*1) in matlab.

I want to write the whole array into excel without using a loop.

xlswrite ('DIESEL_DATA_ALLROUTES_ALLANALYZERS',m_co2_g_sec(:),1,'B2:B2')

i wrote that but it is writing only one value.

is there any easy way to do that??

Answer 1

[dpb]

You only provided a single cell in the range 'B2:B2' so you got what you asked for...use

rnge=num2str(length(m_co2_g_sec)+1,'B2:B%d');
xlswrite ('DIESEL_DATA_ALLROUTES_ALLANALYZERS',m_co2_g_sec(:),1,rnge)