Update Power Query Formula Item

Usage Scenario

There might be cases where the data source files are moved and the excel file is unable to locate the file. In such cases, Aspose.Cells for Python via .NET API provides the option to update the Power Query Formula item by using the PowerQueryFormulaItem class to update the location of the source file.

Updating Power Query Formula Item

Aspose.Cells for Python via .NET API provides the ability to update Power Query Formula Items. The following code snippet demonstrates updating the data source file location in the excel file by using the PowerQueryFormulaItem.value property. The source and output files attached for your reference.

Sample Code

Read and Write External Connection of XLS and XLSB files Check if Workbook contains hidden External Links