We have the following file: Power Query Error.xlsx.zip (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;
}
@infotron,
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
@infotron,
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!
@infotron,
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).