writing an array to excel

53 views (last 30 days)
sri satya ravi
sri satya ravi on 19 Oct 2016
Edited: dpb on 19 Oct 2016
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??

Accepted Answer

dpb
dpb on 19 Oct 2016
Edited: dpb on 19 Oct 2016
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)

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!