Prev: Selective file reading
Next: Simulink different results
From: Rich on 4 May 2010 10:52
Hi,
I am stumped on adding borders to excel cells (I can colour them ok!).
Any suggestions for what I'm doing wrong (snippet below)

mlrange='E1:F15'; % or similar

Excel = actxserver ('Excel.Application');
Excel.Workbooks.Open(filename);
TargetSheet = get(Excel.sheets,'item','A');
TargetSheet.Activate
ran = Excel.Activesheet.get('Range',mlrange);

ran.font.Color=hex2dec('FF0000'); % works fine
ran.BorderAround; %doesn't seem to do anything

%Other option that I could not get to work, not sure how to pass the arguments correctly...:
ran.Borders(xlEdgeBottom).LineStyle = 'xlContinuous'
ran.Borders(xlEdgeBottom).Weight = 'xlThick'

Thanks in advance!
 | 
Pages: 1
Prev: Selective file reading
Next: Simulink different results