title: Is there any way to define table area using excel programatically with dynamic data?
body: <p>I have a sheet that contains a table (produced from jasper report query). This table will be the source of my pivot table. The Pivot is created using an external connection (From Microsoft Query). since the source table needs to be defined before it can be used in Micrososft Query, could anyone show me how to do it programatically?</p>
  
  <p>INFO: </p>
  
  <ol>
  <li>There are 2 documents here, the first is a protected source data and the second is a Pivot document.</li>
  <li>The data is dynamic and the table contains a header.</li>
  </ol>
  
  <p>Is there any way to define the table area using excel programatically with dynamic data?</p>