Dynamically change column in excel worksheet inside a for loop
3 views (last 30 days)
Show older comments
Hi,
Can somebody help me how I can modify/include the follwing code to dynamically write output to Excel file inside a for loop starting from the cell "C9" to advance upto 200 columns?
for i=1:200
Data1{:,i}=prcp(RowID(i,1):RowID(i,2),5);
xlswrite('test.xls',Data1{1,i},'Zone01','??')
end
Thanks in advance,
0 Comments
Answers (1)
Image Analyst
on 25 Sep 2014
Oh my gosh. You definitely don't want to do that, unless you have lots of time to wait or have solid state drives (faster than hard drives by a lot). Launching Excel 200 times, tossing data into it 200 times, saving the file 200 times, and shutting down Excel 200 times will take a very long time. You want to use ActiveX anytime you need to call xlswrite more than about 4 or 5 times. Attached is a demo. With ActiveX, you launch once, toss data in as many times as you want lightning fast, save it once and shut it down once.
6 Comments
Image Analyst
on 25 Sep 2014
Is RowID integers, and prcp an array of doubles? And why are you using a cell array for Data1 rather than just a regular old double array? Also, you need to derive the cell reference for Excel. You're stuffing all of these arrays into the same location. Maybe you should just do
for i=1:10
row1 = RowID(i,1);
row2 = RowID(i,2);
Data1 = prcp(row1:row2,5); % Col5 between row1 and row2
cellReference = sprintf('C%d:C%d', row1, row2);
xlswrite1('test.xls', Data1, 'test', cellReference)
end
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!