Accessing PowerQueryFormula results in exception of Invalid Power Query formula

We have the following file: Power Query (55.7 KB)
This file has 21 Power Query data connections. However, all connections raise an exception when accessing the PowerQueryFormula property.

Example code:

var workbook = new Workbook("Power Query Error.xlsx");
var externalConnections = workbook.DataConnections;

foreach (var externalConnection in externalConnections)
    var connection = (DBConnection) externalConnection;
    var powerQueryFormula = connection.PowerQueryFormula;

We have reproduced this issue here and logged it in our database for further investigation and a fix. You will be notified here once any update is ready for sharing in this regard.

This issue is logged as:
CELLSNET-47649 - Exception is raised while reading DBConnection.PowerQueryFormula from XLSX file


Please try our latest version/fix: Aspose.Cells for .NET v20.9.11 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells20.9.11 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.9.11 For .Net4.0.Zip (5.4 MB)

Yes, I can confirm that the issue is fixed in Aspose.Cells 20.9.11. Thank you!


Thanks for your feedback and good to know that your issue is resolved by the new fix.

The issues you have found earlier (filed as CELLSNET-47649) have been fixed in Aspose.Cells for .NET v20.10. This message was posted using Bugs notification tool by Amjad_Sahi. You may also get the version @ Nuget repos. (NuGet Gallery | Aspose.Cells 20.10.0).