Change the Absolute Path of External Link Data Source File with C++

Possible Usage Scenarios

If you want to change the absolute path of the external link data source file, then please use the GetAbsolutePath() method. Initially, this property will be set to the path from where the Excel file was loaded. However, you can set it to an empty string, or you can set it to a local folder path or a remote network path. Whenever you change this property, the path of the external link data source file will also be changed.

The following sample code loads the sample Excel file which contains an external link. It first prints the external link data source, which shows the remote path. Then it removes the remote path and prints again; this time it prints the external link data source with the local path. Then it changes the Workbook.AbsolutePath to a local and a remote path, prints the external link data source again, and the changes are reflected in the console output.

Here is the console/debug output after executing the sample code with the sample Excel file.

External Link Data Source: http:\\ws874dmErit\WebFiles\Files\300\ExternalAccounts.xlsx

External Link Data Source After Removing Remote Path: D:\Downloads\ExternalAccounts.xlsx

External Link Data Source After Changing Workbook.AbsolutePath to Local Path: C:\Files\Extra\ExternalAccounts.xlsx

External Link Data Source After Changing Workbook.AbsolutePath to Remote Path: http://www.aspose.com/WebFiles/ExcelFiles/ExternalAccounts.xlsx

Check if Workbook contains hidden External Links with C++