title: When outputting multiple sheets using ods tagsets.ExcelXP and body=test.html it doesn't work as intended
body: <p>I am outputting several tables into several worksheets in one xml type Excel spreadsheet.</p>
  
  <p>The problem I am having is that out of the six worksheets I am outputting, the final four are using a body=test.html as well, to allow certain style formats to work (which only work if I use the body= command). When it runs however, the first two worksheets are output and the final four are not. </p>
  
  <p>eg.</p>
  
  <pre><code>ods tagsets.excelxp file='example.xls' options(...sheet_name=sheet1...);
  
  proc report;
  run;
  
  ods tagsets.excelxp options(...sheet_name=sheet2...);
  proc tabulate;
  run;
  
  ods tagsets.excelxp body='test1.html' options(...sheet_name=sheet3...);
  proc report;
  run;
  ods tagsets.excelxp body='test2.html' options(...sheet_name=sheet4...);
  proc report;
  run;
  ods tagsets.excelxp body='test3.html' options(...sheet_name=sheet5...);
  proc report;
  run;
  ods tagsets.excelxp body='test4.html' options(...sheet_name=sheet6...);
  proc report;
  run;
  
  ods tagsets.excelxp close;
  </code></pre>
  
  <p>The first two are output fine, but the final four are not. I have tried placing the <em>body='test.html'</em> for each ods tagsets.excelxp line, but it doesn't work and just outputs the first sheet. I cannot skip out the ods tagsets.excelxp lines as I need different options for each sheet...is there a way to output these in the same spreadsheet? I am not allowed to use VBA or any manual interventions.</p>