I am writing simulation results from Matlab to Excel. In order to make it easier to read I apply some formating to the output. It works fine to change font size, font color, number format etc but applying a border around a selected number of cells doesn't work.
Example:
% -- Create excel sheet --
AppObj = actxserver('Excel.Application');AppObj.Visible = true;WkbkObj = AppObj.Workbooks;DataWkbkObj = WkbkObj.Add;DataWkbkObj.Sheets.Add().Name = 'Test';DataSheetObj = DataWkbkObj.Sheets.Item('Test');% -- Write some data --
DataSheetObj.Range('B2').Value = 43;DataSheetObj.Range('B3').Value = 5;DataSheetObj.Range('B4').Value = 7;% -- Apply blue color --
DataSheetObj.Range('B2:B4').Font.Color = -4165632;% -- Change number format --
DataSheetObj.Range('B2:B4').NumberFormat = '0,00';% -- Apply a line on the left side --
DataSheetObj.Range('B2:B4').Borders('xlEdgeLeft').LineStyle = 'xlContinuous';DataSheetObj.Range('B2:B4').Borders('xlEdgeLeft').Weight = 'xlMedium';
The last two lines doesn't work. The problem is the 'xlEdgeLeft' part. I have tried to analyze the object and use constant values without result. Any ideas?
Best Answer