Create Dashboard report instantly, enter a SQL query and click Publish dashboard 
This zip file contains files - INSTALL_AND_ACTIVATE_AUTO_DASHBOARD_PIVOT.xlsm 
 
Note: If you're connecting to Oracle Database ensure, SQLCLI is downloaded to your machine.
This solution requires SQLCLI to work as shown in the demo video
https://download.oracle.com/otn_software/java/sqldeveloper/sqlcl-latest.zip