MATLAB: Writing an array to excel

exporting

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??

Best Answer

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)
Related Question