We really need a way to dynamically determine the range for a table. Something that works like "Range.CurrentRegion" in VBA.
Ideally, the whole need for Excel data to be formatted as a table would be eliminated entirely, and we could just use a connector/action to return an object that contained the data.
Having to know the range of a table prior to automation extremely limits the functionality/capability of the tool.