title: R: How can you freeze the top row in an exported Excel file using R code?
body: <p>Solution must be in R.
  Related questions are providing solution for other languages. (e.g., here <a href="https://stackoverflow.com/questions/16963370/freeze-top-row-using-spreadsheetgear">freeze top row using spreadsheetgear</a>)</p>
  
  <p>An Excel counterpart of</p>
  
  <pre><code>library(tidyverse)
  mtcars %&gt;% write_csv('IneedExcelNotCSV.csv')
  </code></pre>
  
  <p>with some part of code that freezez the  top row.</p>
  
  <p>Solution for similar format to .xls(x) (e.g., OpenOffice) would work too. (.sxc?)</p>