title: How to hide excel gridlines using OpenXML SDK
body: <p>Im using OpenXML SDK 2.5 for creating excel file. I want to hide gridlines on created excel files.I was tried creating SheetViews but it completely hide sheet. My pure code as below </p>
  
  <pre><code>public static SpreadsheetDocument CreateWorkbook(MemoryStream memoryStream)
      {
          var spreadSheet = SpreadsheetDocument.Create(memoryStream, SpreadsheetDocumentType.Workbook);
  
          spreadSheet.AddWorkbookPart();
          spreadSheet.WorkbookPart.Workbook = new Workbook();
          spreadSheet.WorkbookPart.Workbook.Save();
  
          var sharedStringTablePart = spreadSheet.WorkbookPart.AddNewPart&lt;SharedStringTablePart&gt;();
          sharedStringTablePart.SharedStringTable = new SharedStringTable();
          sharedStringTablePart.SharedStringTable.Save();
  
          spreadSheet.WorkbookPart.Workbook.Sheets = new Sheets();
          spreadSheet.WorkbookPart.Workbook.Save();
  
          var workbookStylesPart = spreadSheet.WorkbookPart.AddNewPart&lt;WorkbookStylesPart&gt;();
          workbookStylesPart.Stylesheet = new Stylesheet();
          workbookStylesPart.Stylesheet.Save();
  
          memoryStream.Seek(0, SeekOrigin.Begin);
  
          return spreadSheet;
      } 
  
      public static bool AddWorksheet(SpreadsheetDocument spreadsheet, string name)
      {
          Sheets sheets = spreadsheet.WorkbookPart.Workbook.GetFirstChild&lt;Sheets&gt;();
  
          var worksheetPart = spreadsheet.WorkbookPart.AddNewPart&lt;WorksheetPart&gt;();
          worksheetPart.Worksheet = new Worksheet(new SheetData());
  
          worksheetPart.Worksheet.Save();
  
          var sheet = new Sheet()
          {
              Id = spreadsheet.WorkbookPart.GetIdOfPart(worksheetPart),
              SheetId = (uint)(spreadsheet.WorkbookPart.Workbook.Sheets.Count() + 1),
              Name = name
          };
          if (string.IsNullOrEmpty(name)) {
              sheet.Name = string.Format("Sheet{0}", sheet.SheetId);
          }
          sheets.Append(sheet);
          spreadsheet.WorkbookPart.Workbook.Save();
  
          return true;
      }
  </code></pre>
  
  <p>After that im creating instance of spreadsheet in memory</p>
  
  <pre><code>//Creating like that
          var memoryStream = new MemoryStream();
          var spreadsheet = CreateWorkbook(memoryStream);       
          AddWorksheet(spreadsheet, null);
  //End Filling data
  </code></pre>
  
  <p>After some check i decide to, when you use the column you couldnt hide gridlines. You should only cell for showing data. But that time you couldnt change width property bacause column doesnt extist :)</p>