writing an array to excel

19 vues (au cours des 30 derniers jours)

sri satya ravi le 19 Oct 2016

Modifié(e) : dpb le 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??

dpb le 19 Oct 2016

Modifié(e) : dpb le 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)

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

En savoir plus sur Spreadsheets dans Help Center et File Exchange

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

Translated by