Date: Mar 8, 2013 3:39 PM
Author: ryanshuell@gmail.com
Subject: Re: Matlab excel interface

What the heck???  I find it hard to believe that you' can't write 100 rows of data to Excel from Matlab.  Excel can handle a little over a million rows; Matlab can handle much more.  You must be doing it wrong.  Check out the samples here:
http://www.mathworks.com/help/matlab/ref/xlswrite.html

More samples here:
http://matlab.izmiran.ru/help/techdoc/ref/xlswrite.html

Finally, see these two examples:
http://www.mathworks.com/matlabcentral/fileexchange/2855-xlswrite/content/xlswrite.m
http://www.mathworks.com/matlabcentral/fileexchange/27236-improved-xlswrite-m/content/xlswrite.m


"james bejon" wrote in message <kgvs28$osu$1@newscl01ah.mathworks.com>...
> Ah, you may have to do it the slow way then, i.e. opening an instance of Excel and writing to it one cell at a time. I don't have Excel (or Matlab) to hand, but something like this perhaps:
>
> % Data
> dat = repmat({char(64+ceil(rand(1,2000)*26))}, 10, 10);
>
> % Excel handles
> xlsApp = actxserver('Excel.Application');
> xlsWbk = invoke(xls.Workbooks, 'Add');
> xlsSht = invoke(xlsWbk.Worksheets, 'Item', 1);
> xlsRng = invoke(xlsSht, 'Range', 'A1');
>
> % Action
> for i = 1:size(dat, 1)
> for j = 1:size(dat, 2)
>
> set( get(xlsRng, 'Offset', i-1, j-1), 'Value', dat{i, j} )
>
> end
> end