title: How to make excel work sheet header row bold using OpenXML
body: <p>I am using <code>openXML</code>, Asp.net and c# to create an <code>Excel workbook</code>, I have a requirement that to make Header row of all sheets should be bold.</p>
  
  <pre><code>WorkbookStylesPart stylesPart = workbookpart.AddNewPart&lt;WorkbookStylesPart&gt;();
          stylesPart.Stylesheet = CreateStylesheet();
          stylesPart.Stylesheet.Save();
  
      }
      private static Stylesheet CreateStylesheet()
      {
          Stylesheet ss = new Stylesheet();
          Fonts fts = new Fonts();
          DocumentFormat.OpenXml.Spreadsheet.Font ft = new DocumentFormat.OpenXml.Spreadsheet.Font();
          Bold fbld = new Bold();
          FontName ftn = new FontName();
          ftn.Val = "Calibri";
          DocumentFormat.OpenXml.Spreadsheet.FontSize ftsz = new DocumentFormat.OpenXml.Spreadsheet.FontSize();
          ftsz.Val = 11;
          ft.FontName = ftn;
          ft.FontSize = ftsz;
          ft.Bold = fbld;
          fts.Append(ft);
          fts.Count = (uint)fts.ChildElements.Count;
          ss.Append(fts);
          return ss;
      }
  </code></pre>
  
  <p>It is making all the cells <code>bold</code>, I am missing the code that apply this to a particular <code>row/cells</code></p>
  
  <p>Thanks in Advance,
  AR </p>