We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

.XlsIO.Implementation.WorksheetImpl.GetXFIndex(Int32 iRow, Int32 iColumn)

Hi ,
Am using SyncFusion Tool dll in my application for Excel Generation ,
But am getting error : below , not always , but in a random manner.

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[NullReferenceException: Object reference not set to an instance of an object.]

   Syncfusion.XlsIO.Implementation.WorksheetImpl.GetXFIndex(Int32 iRow, Int32 iColumn) +34

   Syncfusion.XlsIO.Implementation.RangeImpl.get_Item(String name, Boolean IsR1C1Notation) +489

   GERD.Documents.Excel.ExcelHelper.CreateImportReportCompPlannerUpload(IList`1 messages, Stream output, String filePath, String errorFileName, Dictionary`2 logCount) in C:\tfsProduction\Gerd\Releases\4.4\Source\GERD\GERD.Documents\Excel\ExcelHelper.cs:954

   GERD.Web.SoscUpload.ubxTextUploadCompPlannerFile_BeforeFileSave(Object sender, EventArgs e) in C:\tfsProduction\Gerd\Releases\4.4\Source\GERD\GERD.Web\SoscUpload.aspx.cs:294

   Syncfusion.Web.UI.WebControls.Tools.UploadBox.OnBeforeFileSave(EventArgs e) +68

   Syncfusion.Web.UI.WebControls.Tools.UploadBox.RaisePostDataChangedEvent() +162

   System.Web.UI.Page.RaiseChangedEvents() +88

   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2776

Can you any please help on this.

1 Reply

RA Rajesh A Syncfusion Team August 26, 2013 04:32 AM UTC

Hi Rigin,

Thank you for using the Syncfusion products.

We are not able to see the above reported issue” Object reference not set to an instance of an object” from our side. Kindly check with our latest version and get back to us with issue reported sample or code snippet with input file, if the issue is reproducing. It will help us to investigate further on this issue.

Also, you can open an incident from DirectTrac to report the same in future.

DirectTrac Login Link: Login

Our Latest Version Link
: http://www.syncfusion.com/downloads/latest-version

Please let us know if you need further assistance.



Live Chat Icon For mobile
Up arrow icon