CODEWITHSUNDEEP
c#wpfexcelvisibilitygridlines
Patrick
Patrick

Reputation: 2583

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

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

Upvotes: 4

Views: 5596

Answers (2)

ding dong
ding dong

Reputation: 11

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.

Upvotes: 0

Szabolcs D&#233;zsi
Szabolcs D&#233;zsi

Reputation: 8843

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;

Upvotes: 12

Related Questions