Gridlines in excel through interop

Question

Any idea where the setting is hiding for turning gridlines off while using excel 2003 from interop?

Jon Fournier · Accepted Answer · 2009-01-30T21:44:18.217

11

DisplayGridlines is a method on an Excel Window object. For example:

ActiveWindow.DisplayGridlines = true

edited Jan 30 '09 at 21:44

answered Jan 30 '09 at 21:22

Jon Fournier

4,299
3
33
43

score 4 · Answer 2 · edited Nov 15 '11 at 19:01

4

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

edited Nov 15 '11 at 19:01

Leo

37,640
8
75
100

answered Sep 06 '11 at 16:14

Kevakapob

41
1

score 3 · Answer 3 · edited Jan 13 '14 at 10:37

3

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

write the code just before save excel code line.

edited Jan 13 '14 at 10:37

kleopatra

51,061
28
99
211

answered Jan 13 '14 at 10:32

dfds

31
1

Seems this is the only snippet that actually pops up as members in Visual Studio, nice going – James Heffer Nov 22 '16 at 08:59

score 2 · Answer 4 · edited Jun 09 '15 at 17:48

2

Currently, using VS2012 and I did 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

edited Jun 09 '15 at 17:48

shruti1810

3,920
2
16
28

answered Jun 09 '15 at 17:28

Humbert

41
2

I have not set them, and they are off, so I'm not sure true is the default. – B. Clay Shannon-B. Crow Raven Nov 25 '15 at 23:39

score 1 · Answer 5 · edited Jul 11 '16 at 08:14

1

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

edited Jul 11 '16 at 08:14

maialithar

3,065
5
27
44

answered Jan 30 '09 at 21:37

shahkalpesh

33,172
3
63
88

Gridlines in excel through interop

5 Answers5

Linked