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

Free Support Forum - aspose.com

Exception while calling Cells.DeleteBlankRows

Hi @ahsaniqbalsidiqui

Thank you for providing new URLs. Unfortunately we were still able to reproduce the issue using Aspose.Cells 18.12.1. Upon calling sheet.Cells.DeleteBlankRows() we get the following exception:

System.ArgumentException: Destination array is not long enough to copy all the items in the collection. Check array index and length.
at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at System.BitConverter.ToInt32(Byte[] value, Int32 startIndex)
at .(Worksheet , Boolean , Int32 , Int32, Int32 , Int32 , Int32 , Int32 , Byte[] )
at ? .(Int32 , Int32 , Worksheet , Boolean)
at Aspose.Cells.RowCollection(Int32 , Int32 )
at Aspose.Cells.Cells.(Int32 , Int32 , DeleteOptions )
at Aspose.Cells.Cells.DeleteBlankRows(DeleteOptions options)

We’ve created a sample console app which allows to easily reproduce the issue, including the Excel file: https://we.tl/t-6BOqZzB7cF

Looking forward to your feedback. Please let us know if you need more info.



We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46543 - Exception while calling Cells.DeleteBlankRows


This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-46543”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.


Please try our latest version/fix: Aspose.Cells for .NET v18.12.9 (attached)

Your issue should be fixed in it.

Let us know your feedback.

Aspose.Cells18.12.9 For .Net4.0.Zip (4.7 MB)
Aspose.Cells18.12.9 For .Net2_AuthenticodeSigned.Zip (4.7 MB)

@ahsaniqbalsidiqui the provided assembly does fix our issue. Do you know when we can expect this version released via the following NuGet feed: https://www.nuget.org/packages/Aspose.Cells ? Many thanks!


We will release new updated version via NuGet in about 10 days. You will be notified here once new version is released and ready for download.

1 Like

The issues you have found earlier (filed as CELLSNET-46543) have been fixed in Aspose.Cells for .NET v19.1. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi

1 Like