Merge two xlsx files with power-queries inside

Aspose.Cells Product Family
1

Hello. I need to merge two xlsx files that have power-queries inside them. I first tried to use Workbook.combine method but it didn’t work. Then I tried to use CellsHelper.mergeFiles but in the destination xlsx file there was power-query from the first file only. Please explain how can I merge 2 such files using aspose-cells? I have attached xlsx files with power queries inside.
test.zip (53,4 КБ)

2

@s.petrishchev,

Thanks for the template XLSX files.

After an initial test, I am able to reproduce the issue as you mentioned by using your sample XLSX file. I found that when merging two XLSX files (each with power queries inside), the resultant file has the power query of one workbook but not the other.

We require thorough 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): CELLSJAVA-45985

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.

3

@s.petrishchev,

This is to inform you that your issue (logged as “CELLSJAVA-45985”) has been resolved. The fix will be included in an upcoming release (Aspose.Cells v24.6) that we plan to release in the first half of June 2024. You will be notified when the next version is released.

1 Like
4

The issues you have found earlier (filed as CELLSJAVA-45985) have been fixed in Aspose.Cells for Java 24.6.

5

Hello! I found another problem: I get the message “Invalid Power query formula definition” when merging two xlsx files (please see attached zip). Can you look at this issue? And if possible, can you add information about the row and column where the formula is invalid? Thank you
mergeTest.zip (64,8 КБ)

6

@s.petrishchev,

Thanks for the sample files and details.

After an initial testing, I reproduced the issue you mentiioned by using your template XLSX files. I found an exception “com.aspose.cells.CellsException: Invalid Power query formula definition” on merging files.

We need to evaluate your issue in details. 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): CELLSJAVA-46030

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.

7

@s.petrishchev,

This is to inform you that your issue (logged as “CELLSJAVA-46030”) has been resolved now. The fix/enhancement will be included in the next release (Aspose.Cells v24.7) that we plan to release in the second week of July (next month). You will be notified when the next version is released.

8

The issues you have found earlier (filed as CELLSJAVA-46030) have been fixed in Aspose.Cells for Java 24.7.