Prev: Accelerate MATLAB with QLA 1.0
Next: finding complex root from nonlinear equations
From: Naftali Herscovici on 15 Jun 2010 11:03
Hello,

I fond some information on how Matlab controls excel.

for filling cells I found this

% Put a MATLAB array into Excel
A = [1 2; 3 4];
ActivesheetRange = get(Activesheet,'Range','A1:B2');
set(ActivesheetRange, 'Value', A);

I was wondering if the cells command could be used like this

A = [1 2; 3 4];
ActivesheetRange = get(Activesheet,'Range','cells(1,1),cells(2,2)');
set(ActivesheetRange, 'Value', A);

Thanks

Tuli
From: sscnekro on 15 Jun 2010 13:48
Would this be helpful?
ActivesheetRange = get(Activesheet,'Range',['A' num2str(ii)],['A' num2str(ii)]);

I fetched it from:
http://www.mathworks.com/matlabcentral/fx_files/7881/1/xlswrite.m
 | 
Pages: 1
Prev: Accelerate MATLAB with QLA 1.0
Next: finding complex root from nonlinear equations