dimanche 19 avril 2015

convert simple VB script to MATLAB

I have some problem converting simples VB scripts (formating) into MATLAB:


VB script:



Range("A1").Select
Selection.Font.Italic = True
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
End With


I tried:



xlswrite('test.xls',1,'A1');
Excel = actxserver('Excel.Application');
Excel.Workbooks.Open('test.xls');

Range = Excel.Range('A1');
Range.Font.Italic = True; % Doesnt work
Range.Border.Item('xlEdgeRight').LineStyle = 1; % Doesnt work

Excel.Visible = 1;


Any workaround? Thanks


Aucun commentaire:

Enregistrer un commentaire