Retrieving External Data Sources Details
Contents
[
Hide
]
Sometimes, you might want to retrieve information about external data sources. For example, you might want to see the SQL connection data. This information can include any types of data required to connect to an SQL server, for example the server URL, user name, underlying table name, SQL query, query type, the location of the table, etc.
Aspose.Cells provide some useful calls for retrieving such details from corporate databases linked to template Excel files.
Retrieving External Data Sources Details
The following example shows how to get database connection and other details. The example utilizes a simple Excel file that contains links to external data source (SQL Server).
When the code runs, the connection details are printed to the console.
SQL connection information
