How to loop string files with the help of xlswrite to write on new areas of same sheet an excel file

2 次查看（过去 30 天）
navan
navan 2015-6-26
评论： navan 2015-6-26
I would like to write my matlab workspace file 'frequencycurve' to an excel file 'frequency.xlsx'. I want to loop my program each time so that it writes my 'frequencycurve' to new aera of the same sheet of excel file.
I want to write first loop data into A1:C5 then A2:C6 till A10:C15 of the excel file.
I use following code but is not working. Kindly help.
filename = 'frequency.xlsx';
for i=1:10
for j=5:15
range='A(i):C(j)';
xlswrite(filename,frequencycurve,range)
end
end
I want to write first loop data into A1:C5 then A2:C6 till A10:C15 of the excel file.

请先登录，再回答此问题。

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2015-6-26
编辑：Azzi Abdelmalek 2015-6-26
ii=2,
jj=3,
range=sprintf('A%d:C%d',ii,jj)

更多回答（1 个）

Image Analyst
Image Analyst 2015-6-26
Each call to xlswrite() launches Excel, opens the workbook, transfers the data, saves the workbook, and shuts down Excel. You'd be launching Excel 110 times, and shutting down Excel 110 times. This will take a very long time. You should learn how to make up an array to call xlswrite() just one time AFTER the loop.
Or else use ActiveX (if you're using Windows) so that you just open Excel once and shutdown Excel once, with 110 pokes of data (which will be instantaneous). I've attached a demo of using ActiveX to control Excel.

类别

在 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