Free Support Forum - aspose.com

Getting Null pointer Exception at: com.aspose.cells.Worksheet.autoFitColumns(Unknown Source) / com.aspose.cells.Cell.getStyle(Unknown Source)

Hi,

We are using the Aspose.Cells.jar version of 2.1.0.6. From our application we are trying to generate a Excel Workbook by using Aspose, which contains >= 180 Worksheets.

Now we are getting the following Runtime Exception of java.lang.NullPointerException at com.aspose.cells.Worksheet.autoFitColumns(Unknown Source).

The same piece of code is working fine if we try to generate a Excel Workbook which contains < 180 WorkSheets.

(Note: If we comment the Worksheet.autoFitColumns() in our code, now we are getting the same kind of error at com.aspose.cells.Cell.getStyle(Unknown Source))

I have attached the errorLog.zip file for your reference.

Can you please help us to rectify this issue? Thanks in advance.

Thanks & Regards,

Karuppiah M

Hi Karuppiah,

Please try the latest version/fix (attached) v2.1.1.5 (in which we have made some enhancements for auto-fit and other operations).

If you still find the issue, kindly create a sample console application to show the issue, we will check it soon.

Thank you.