Gridlines in excel via interop

Question

Any idea where the setting is hiding to disable grid lines when using excel 2003 from interop?

Answer 1

DisplayGridlines is an Excel object method. For example:

ActiveWindow.DisplayGridlines = true 

Answer 2

 using Excel = Microsoft.Office.Interop.Excel; Excel.Application oXL; oXL.Windows.get_Item(1).DisplayGridlines = false; 

Answer 3

 oXL.Windows.Application.ActiveWindow.DisplayGridlines = false; 

write code before saving the excel code line.

Answer 4

Currently using VS2012 , and I have done it as follows:

 Excel.Application oXl = new Excel.Application(); oXl.Visible = false; // true for debug Excel.Workbook wb = oXl.Workbooks.Add(); Excel.Worksheet ws = wb.Worksheets[1]; oXL.ActiveWindow.DisplayGridlines = false; //true is the default in Excel 

Answer 5

ActiveWorkbook.Windows(1).DisplayGridlines = True 'OR False