We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Aspose.Cells v22.2 - fails to MergeExcelFileFromJson (GridJsWorkbook)


We are trying to upgrade Aspose.Cells (for .NET) to the new released version- v22.2 (the motivation is using the AbstractCalculationEngine).

We had a working test that fails after upgrading to v22.2.
The failure is in GridJsWorkbook.MergeExcelFileFromJson. We used to open this BasicTestToSaveData.zip (583 Bytes) JSON as the JSON input for this method, and we get an exception: System.NullReferenceException: 'Object reference not set to an instance of an object.'

Can you please advice?



Please notice, we have logged a ticket with an id “CELLSGRIDJS-526” for your issue. We will evaluate and look into the details of the issue to figure it out soon.

Once we have an update on it, we will let you know.

we 've fixed it in the next fix version

Thanks for quick response!

When should we expect the next version?

we will send out the fix tomorrow, after test

Hi @peter.zhou
Will this be provided as a hotfix or will it be part of the next version?



The fix will be included in our next (regular) release: Aspose.Cells for .NET v22.3. The next version is scheduled to be published in the second week of March, 2022. You will be notified in the thread once the release is published.

Hi - is there any update about the new version?
I can see that there is a new version for Aspose.Cells, I guess that for this issue we’ll need Aspose.Cells.GridJs - is this correct?

When do we expect to have the new version of Aspose.Cells.GridJs?


Please try our latest version/fix: Aspose.Cells for .NET v22.3, you may download/get it from Downloads section. Please either install Aspose.Cells for .NET package using its MSI Installer or extract the Dlls version. You may then find/get Aspose.Cells.GridJs 22.3 library from “…\Dlls\netstandard2.0” folder and try it.

You can also get it through nuget package update.
the demo is also updated :