How to disable gridlines in excel sheet using matlab script

Need to disable gridlines which appear in the excel report generated

Answer 1

[ES]

You have to use ActiveX

% Create COM object for the current Sheet.
objExcel=actxserver('excel.application');
objExcelW=objExcel.Workbooks;
objExcelF=objExcelW.Open(sExcelFileName));
objExcelS=objExcelF.ActiveSheet;

objExcelS.DisplayGridlines = False

% Delete the COM Object.
objExcelF.Save;
objExcelF.Close;
objExcel.Quit;
objExcel.delete;

[kamalakar]

Hi Smith thank you for the reply but ths did not work for me. The below is the error occurred

No public property DisplayGridlines exists for class Interface.000208D8_0000_0000_C000_000000000046.

[Tyler Goodell]

Yeah same here.

[SS585]

This does not work, is there any other solution?

[Tyler Merritt]

I was getting the same error, finally found a solution that worked for me.

% Open Excel and make it visible

AppObj = actxserver('Excel.Application');

AppObj.Visible = true;

% Select workbooks

WkbkObj = AppObj.Workbooks;

% Turn off gridlines in active workbook

WkbkObj.Application.ActiveWindow.DisplayGridlines = false;