writing an array to excel

23 次查看（过去 30 天）
sri satya ravi
sri satya ravi 2016-10-19
编辑： dpb 2016-10-19
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
dpb 2016-10-19
编辑：dpb 2016-10-19
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)

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by