Power query details not retrieved

[rafik2k10]

@ahsaniqbalsidiqui

Could you please try below code snippet to access PowerQueryFormulas and let us know your feedback.

Workbook workbook = new Workbook("PowerQueries.xlsx");
var dataMashup = workbook.DataMashup;

foreach(var powerQuery in dataMashup.PowerQueryFormulas)
{
    foreach (var item in powerQuery.PowerQueryFormulaItems)
    {
        Console.WriteLine(item.Value);
    }
    Console.WriteLine("\n");
} 

Moreover, we have fixed your issue (logged earlier as “CELLSJAVA-43073”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

See attached file:
SampleFile.zip (15.4 KB)

This file has power query details (See in Excel 2016 or 2019) but Aspose is not able to get this and return “dataMashup.PowerQueryFormulas” as nothing.

[ahsaniqbalsidiqui]

@rafik2k10,
We have observed this issue and logged it in our database for further investigation. You will be notified here once any update is ready for sharing.

This issue is logged as:
CELLSNET-49145 - DataMashup information not retrieved from Excel file

[amjad.sahi]

@rafik2k10,

This is to inform you that we have fixed your issue now. We will provide you the fixed version within the next few days after performing QA and incorporating other enhancements and fixes.

[simon.zhao]

@rafik2k10
The issue is fixed in v21.9.1.
Aspose.Cells21.9.1 For .Net2_AuthenticodeSigned.Zip (5.6 MB)
Aspose.Cells21.9.1 For .NetStandard20.Zip (5.6 MB)
Aspose.Cells21.9.1 For .Net4.0.Zip (5.6 MB)

[rafik2k10]

Thanks for the fix. The issue is resolved now.

[ahsaniqbalsidiqui]

@rafik2k10,
Good to know that your issue is sorted out. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

[aspose.notifier]

The issues you have found earlier (filed as CELLSNET-49145) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao