How to hide gridlines in an excel sheet through C# WPF

Question

Following this

http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Worksheet/How-to-hide-or-show-gridlines-on-a-worksheet-in-C.html

to hide gridlines I should do just:

Workbook wb = app.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
  Worksheet ws = wb.Worksheets[1];
   ws.GridLinesVisible = false;<----WRONG

but that is wrong.

And also the solution here

How to disable gridlines in Excel using open xml C#?

does not work. So any other method?

thank you in advance. PAtrick

Why is it "WRONG"? Does it give an error? Does it not compile? — Jcl
– Jcl, Commented Feb 6, 2016 at 18:32
You are following a tutorial for a library (Spire.XLS)... are you actually using that library? — Jcl
– Jcl, Commented Feb 6, 2016 at 18:54
So awkward of me ...no i didn t noticed it. Any other way to set excel gridlines off with no added library? — Patrick
– Patrick, Commented Feb 6, 2016 at 19:30

Szabolcs Dézsi · Accepted Answer · 2016-02-06 19:32:11Z

12

With no third party library, using only the simple Excel interop (Microsoft.Office.Interop.Excel), it should work with this:

Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();

xlApp.Visible = true;

Workbook wb = xlApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
Worksheet ws = wb.Worksheets[1];

xlApp.ActiveWindow.DisplayGridlines = false;

answered Feb 6, 2016 at 19:32

Szabolcs Dézsi

8,84323 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Benji Altman Over a year ago

Any info on how to hide gridlines on multiple sheets? I only seem to be able to get it on the ActiveWindow (the first sheet).

ding dong · Accepted Answer · 2021-05-02 03:35:48Z

0

For multiple sheets and working with Excel interop, activate each sheet first.

worksheet.Activate();
xlApp.ActiveWindow.DisplayGridlines = false;

Hope this helps those that need to deal with multiple sheets.

edited May 2, 2021 at 3:35

answered Apr 28, 2021 at 8:22

ding dong

112 bronze badges

Collectives™ on Stack Overflow

How to hide gridlines in an excel sheet through C# WPF

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related