Object Reference not set - While Saving Workbook object

Aspose.Cells Product Family
1

Hi Team,

I am getting error "Object reference not set to an instance of an object" randomly while saving Workbook object.

There is no fixed frequency or count when this fails. Most of the time it fails when run 2nd or 3rd time or sometimes does not give error even after running 10 times.

I am using Aspose.Cells.dll version 7.5.3.0.

Pls help us resolving this issue and let me know if you need any other information.

Thanks,

Hetal

2

Hi,


Please download and try the latest fix: Aspose.Cells for .NET 7.7.2.1 if it makes any difference.

It looks like you are using Aspose.Cells in a multithreaded application which allows different threads to work on the spreadsheet(s). For your information, Aspose.Cells (being created in manged .NET APIs) does support multithreading, but you need to consider a few things here. For example, the component can be used in mutlithreading environment, however you will have to create/use separate workbook/ template Excel file instance in separate threads. You cannot share any shared resources between threads least you may find unstable data or corrupt data. If you have any shared resources, then you will have to synchronize the access by yourself. So, please use different workbooks in different threads on a safer side.

If you still find the issue, kindly create a sample console application, zip it and post it here to reproduce the issue on our end, we will check it soon. Also, provide your template files (if you have any).

Thank you.

3

Hi,

I am facing same issue with this version of Aspose dll as well.

Also, I see an issue here. Few of the functions of my original dll (7.5.3.0) version are not compatible in this version of Aspose.cells dll.

Can you also pls list impact of this version change.

Thanks,

Hetal

4

Hi,


There might be some APIs that are obsoleted in the new versions of the product. Could you elaborate your issue/errors which APIs are not compatible in the new version/fix, we will check it and help you through.

Also, we recommend you to kindly see the release notes of different versions that are released after v7.5.3:
http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/default.aspx



Thank you.

5

hi,

Compatibility is something that I can ignore for the time being but the error that I am getting is of most priority for me righ now.

Can you pls help resolving that.

Thanks,

Hetal

6

Hi,


I still suspect it might be an issue with mulithreading, so you have to cope with it accordingly (please see one my previous reply for more information). As requested earlier, we cannot evaluate your issue unless we have your sample application, so we request you to separate the issue regarding Aspose.Cells and kindly create a sample console application (runnable) with v7.7.2.1, zip it and post it here to reproduce the issue on our end, we will check it soon. Also, provide your template files (if you have any).

Thank you.
7

Hi,

We have not implemented multi threading so I don't think so it is multi threading issue.

Its huge code which I cannot post here also as I said this is random. Sometimes I get this error on 2nd attempt or sometimes on 11th attempt.

This is why I am unable to identify this.

Thanks,

Hetal

8

Hi Hetal,

Thank you for the clarification. I am afraid, we still require the sample application to reproduce the problem with latest build of Aspose.Cells for .NET on our end before we could move forward to log an investigation, and towards the correction (if applicable). Please also provide the environment details such as Operating System version, Operating System architecture, Service Pack, target .NET Framework version etc. This information will help us simulate the environment on our end thus increasing the chances of replicating the said problem.

Thank you for your cooperation and understanding.