Exception when reading workbook.DataMashup

We have the following test file: PowerQueryTestFile.xlsx.zip (548.9 KB)

This file contains 17 queries. Unfortunately, when we try to read them by accessing workbook.DataMashup, a NullReferenceException is thrown.

var workbook = new Workbook("PowerQueryTestFile.xlsx");

foreach (PowerQueryFormula powerQueryFormula in workbook.DataMashup.PowerQueryFormulas)
{
...
}

Can you investigate and fix this issue?

@perfectxl,

Thanks for the template Excel file.

After initial testing, I am able to reproduce the issue as you mentioned by using your template Excel file. I found an exception “System.NullReferenceException” when reading workbook.DataMashup.

We require through evaluation of the issue. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-57297

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

@perfectxl
We are pleased to inform you that your issue has been resolved. The fix will be included in our upcoming release (Aspose.Cells for .NET 24.12) that we plan to release in the first half of December 2024. You will be notified when the next version is released.

Thank you.

A related issue is described in this topic: Update order and add group to PowerQueryFormulas. Now that the provided file (PowerQueryTestFile.xlsx) no longer generates an exception, can you verify that the group names and order is the same as in the “Queries & Connections” pane in Excel?

@perfectxl
Thank you for your feedback. CELLSNET-57253 and CELLSNET-57297 have both been fixed. We will notify you promptly once version v24.12 is released.