title: How is it possible to put a PivotTable on a different sheet using Aspose Cells?
body: <p>I see <a href="http://www.aspose.com/docs/display/cellsnet/Pivot+Table+and+Source+Data" rel="nofollow noreferrer">here</a> how to create a PivotTable on the same sheet as the source data, like so:</p>
  
  <pre><code>int index = pivotTables.Add("=A1:C8", "E3", "PivotTable2");
  </code></pre>
  
  <p>The first arg <code>("=A1:C8")</code> is the source data to extract, the second <code>("E3")</code> is the cell that will serve as the NW corner of the PivotTable - on the same sheet.</p>
  
  <p>I need to put my PivotTable on a separate sheet (and then hide the source data tab altogether).</p>
  
  <p>How can I specify that the second argument is on another sheet?</p>