The Profile tool does not have any XLSX Export Options within Automation
When using an automation tool to use the Profile Data task, there's no "XLSX Export Options" availability to enable to select "Single file page-by-page" export mode or any of the options. The only option available is the "Create Report" section which points to where you want the file saved. Running the automation script creates an Excel file, but only the first page is exported showing only 1 sheet tab, the rest of the tabs\pages are missing. PDF seems to work fine, but not Excel.
Using the Profile tool outside of the automation tool in Toad works fine where a uer can select File | Export Document | XLSX File to get an "XLSX Export Options" window that has all the options needed; such as Export Mode "Single file page-by-page. This creates a new Excel file where each page exported is a separate sheet.
Waiting for a fix in a future release of Toad Data Point.