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

Possible Usage Scenarios

If you want to change the absolute path of the external link data source file, then please use the Workbook.absolutePath property. Initially, this property will be set to the path from where the Excel file was loaded. But you can set it to an empty string, or you can set it to some local folder path or 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 prints 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 property to a local and remote path and prints the external link data source again, and changes are reflected in the console output.

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 JavaScript via C++