有没有办法使用excel以动态数据编程来定义表区域？

I have a sheet that contain table (produced from jasper report query). This table will be the source of my pivot table. The Pivot is created using external connection (From Microsoft Query). since the source table need to defined before before can be used in Micrososft Query, could anyone show me how to do it programatically?I have a sheet that contain table (produced fro