Infragistics.Documents.Excel.Workbook.Load Error Object reference not set to an instance of an object.

Not Answered This post has 0 verified answers | 6 Replies | 2 Followers Thread's RSS feed.

Shoaib Siddique
Points 65
Replied On: Tue, Oct 10 2017 3:37 PM Reply

I am getting error (Object reference not set to an instance of an object) while trying to load excel file with macro. This is the old version of excel in which macro saved in the same .xls extension. I can provide the sample file if needed. 

Code:

Infragistics.Documents.Excel.Workbook.Load("c:\temp\test.xls");

  • Post Points: 20

All Replies

[Infragistics] Milko
Points 21,365
Infragistics Employee
Replied On: Wed, Oct 11 2017 1:42 AM Reply

Hello Shoaib,

Loading of Excel workbook containing VBA code is supported in Infragistics Excel Engine. To investigate this further I will need the file you are not able to load. Therefore, please send this file so I can look into this.

Looking forward to your reply.

Sincerely,
Milko
Associate Software Developer

  • Post Points: 20
Shoaib Siddique
Points 65
Replied On: Wed, Oct 11 2017 4:05 PM Reply

Hi 

Attached is the excel file. It is simply crashing on Infragistics.Documents.Excel.Workbook.Load(filepath);

Looking forward for your response....

Regards

Shoaib

  • Post Points: 20
[Infragistics] Milko
Points 21,365
Infragistics Employee
Replied On: Thu, Oct 12 2017 5:48 AM Reply

Hello Shoaib,

I tried to load provided file and received same exception. I have asked our engineering staff to examine this further. To ensure that it will receive attention, I have logged this behavior in our internal tracking system with a Development ID of 243990. This will be assigned to a developer in a future sprint to review my investigation and confirm my findings or to offer a fix, or other resolution.

Please let me know if you need more information.

Sincerely,
Milko
Associate Software Developer

  • Post Points: 20
Shoaib Siddique
Points 65
Replied On: Thu, Oct 12 2017 10:39 AM Reply

Do you have any expected time when you will receive response from your engineering staff ?

Can you suggest any workaround at this point because I am very heavily dependent on Infragistics Excel library and daily I receive bunch of excel files from client and this is special case, even the same file if I open in latest version of excel and save as it in .xlsm, it worked.

Regards

Shoaib

  • Post Points: 20
[Infragistics] Milko
Points 21,365
Infragistics Employee
Replied On: Fri, Oct 13 2017 2:41 AM Reply

Hi Shoaib,

I have escalated your issue in our internal tracking system to highest priority. As soon as we have a fix for this and the fix is confirmed by our quality engineers I will send you a link where you can download the fixed version of our controls. Regarding the workaround I do not have such now. If I came up with something I will get back to you.

In the meantime please let me know for which supported version of Infragistics you will need a fix.

Thank you for using Infragistics Components.

Sincerely,
Milko
Associate Software Developer

  • Post Points: 20
Shoaib Siddique
Points 65
Replied On: Fri, Oct 13 2017 11:26 AM Reply

Hi

The version which is specified in infragisitics excel dll (Infragistics45.WebUI.Documents.Excel.v15.1.dll) is 15.1.20151.2400

Thanks

  • Post Points: 5
Page 1 of 1 (7 items) | RSS