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");
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.
Hi
Attached is the excel file. It is simply crashing on Infragistics.Documents.Excel.Workbook.Load(filepath);
Looking forward for your response....
Regards
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.
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.
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.
The version which is specified in infragisitics excel dll (Infragistics45.WebUI.Documents.Excel.v15.1.dll) is 15.1.20151.2400
Thanks
Any update from the support team ?