title: OpenXML Multiple Sheets
body: <p>I am adding multiple sheets to an excel workbook. I want to have one row on one sheet and the other row on the other sheet. This code puts both rows on both sheets. Any ideas on how to fix this?</p>
  
  <pre><code>        SpreadsheetDocument ssDoc = SpreadsheetDocument.Create(saveFile, SpreadsheetDocumentType.Workbook);
  
          // Add a WorkbookPart to the document
          WorkbookPart workbookPart = ssDoc.AddWorkbookPart();
          workbookPart.Workbook = new Workbook();
          // Add a WorksheetPart to theWorkbookPart
          WorksheetPart worksheetPart = workbookPart.AddNewPart&lt;WorksheetPart&gt;();
          worksheetPart.Worksheet = new Worksheet(new SheetData());
  
          Sheets sheets = ssDoc.WorkbookPart.Workbook.AppendChild&lt;Sheets&gt;(new Sheets());
  
          Sheet sheet1 = new Sheet()
          {   Id = ssDoc.WorkbookPart.GetIdOfPart(worksheetPart),
              SheetId = 1, Name = "Sheet1"
          };
  
          Sheet sheet2 = new Sheet()
          {
              Id = ssDoc.WorkbookPart.GetIdOfPart(worksheetPart),
              SheetId = 2, Name = "Sheet2"
          };
  
          sheets.Append(sheet1);
          sheets.Append(sheet2);
          Worksheet worksheet = new Worksheet();
          SheetData sheetData = new SheetData();
  
          Row headerRow = new Row();
          Cell emptyCell = CreateTextCell(cellHeader, index, "");
          headerRow.Append(emptyCell);
  
          Row newRow = new Row();
          Cell mycell = CreateTextCell(cellHeader, index, "data");
          newRow.Append(mycell);
  
          sheetData.Append(headerRow);
          sheetData.Append(newRow);
  
          worksheet.Append(sheetData);            
          worksheetPart.Worksheet = worksheet;
  
          ssDoc.Close();
  </code></pre>