In order to extract the data from Denodo Virtual DataPort in Excel, I would recommend you to follow the below steps:
* Create an ODBC Data Source Name with the Denodo ODBC drivers available in <Denodo_Home>\tools\client-drivers\odbc and configure with the Virtual DataPort credentials.
Refer to the section [**DSN configuration for ODBC connections to VDP**](https://community.denodo.com/kb/view/document/DSN%20configuration%20for%20ODBC%20connections%20to%20VDP?category=Northbound+Connections) in the Northbound Connections of the Knowledge Base.
(**Note**: if the Excel is 32-bit, Create DSN with 32-bit ODBC driver. If the Excel is 64-bit, Create DSN with 64-bit ODBC driver).
* In Excel, click on **Data** tab, navigate to **Get Data** > **From Other Sources** > **From Data Connection Wizard**
* In **From ODBC** dialog, Select the DSN created.
* Select the tables to introspect the data in Excel.
You can also refresh the source data by clicking the **Refresh All** icon under the Data tab.
Refer to [**Connect to ODBC source**](https://support.office.com/en-us/article/connect-to-an-odbc-source-49b0cf4d-ef78-4ad1-b224-39091c067953#ID0EAACAAA=Newer_versions) in the Microsoft Office support site for more details.
Hope this Helps!