title: Copying format of cells in a row to all populated rows below
body: <p>We are using the AccessDatabaseEngine DLLs to read and write to an .XLSX document without opening it in Excel on the server. I'd like to copy the cell format from a row (in this case row 9) to all the rows below it that are populated.</p>
  
  <p>Unfortunately we do not and will not have Office/Excel installed on the server, so using the Range class doesn't appear to be an option - <a href="https://stackoverflow.com/questions/18542864/copy-format-from-one-row-to-another-using-c-sharp">Copy format from one row to another using c#</a>.</p>
  
  <p>Has anyone done this before just using the AccessDatabaseEngine or is its functionality limited to the values in the cells only?</p>
  
  <p>Any help would be duly appreciated.</p>