title: Need to write data in Excel which has links to another excel workbook Using R
body: <p>I'm trying to write data into an Macro enabled file which has links to another excel file. But when I try to write data using openxlsx package the excel files gets corrupted, below is my code:</p>
  
  <pre><code>wb &lt;-loadWorkbook("C:/Test/Excel.xlsm")
  writeData(wb,df,sheet="sheet1",startRow=2)
  saveWorkbook(wb,"C:/Test/Excel.xlsm", overwrite = TRUE)
  </code></pre>
  
  <p>I have tried xlsx package too but it doesn't support macro enabled file.</p>