This project has moved and is read-only. For the latest updates, please go here.

How to remove the gridlines from Worksheet?

Jul 3, 2013 at 4:17 PM
What can I do to remove the Excel-Worksheet-Gridlines?
I tried
ExcelWorksheet ws = p.Workbook.Worksheets[1];
ws.Cells.Style.Border.Bottom.Style = ExcelBorderStyle.None;
ws.Cells.Style.Border.Top.Style = ExcelBorderStyle.None;
ws.Cells.Style.Border.Left.Style = ExcelBorderStyle.None;
ws.Cells.Style.Border.Right.Style = ExcelBorderStyle.None;
but it doesn't work.
Jul 4, 2013 at 10:22 AM
The answer is...
ws.View.ShowGridLines = false;