Unable to load an excel file in the C1.C1Excel.C1XLBook object

Unable to load an excel file in the C1.C1Excel.C1XLBook object

Posted by: paresh-naik on 10 September 2017, 12:32 pm EST

• 

  paresh-naik

  • Post Options:
  • Link
    Copy

  Posted 10 September 2017, 12:32 pm EST

  Hi,

  I am unable to load the excel file(attached) into the C1.C1Excel.C1XLBook object.

  I am developing an application which parses through this excel file and uploads the data to our database.

  I am using the following piece of code:

  C1.C1Excel.C1XLBook xlBook = new C1.C1Excel.C1XLBook();
  
  xlBook.Load(“The path of the excel file attached”);

  It throws an exception with the message : Failed to open storage file.

  Could someone help?
  
  2011/09/201191210930170244HPM0136575106040.xls

• 

  richas

  • Post Options:
  • Link
    Copy

  Posted 10 September 2017, 12:32 pm EST

  Hello Paresh,

  I am able to replicate the issue. I have escalated this issue to the concerned team. The issue id is 17243.

  Thanks,
  
  Richa

• 

  paresh-naik

  • Post Options:
  • Link
    Copy

  Posted 10 September 2017, 12:32 pm EST

  Hi Richa,
  
  Any updates on issue id 17243?

  Regards,
  
  Paresh

• 

  richas

  • Post Options:
  • Link
    Copy

  Posted 10 September 2017, 12:32 pm EST

  Hello Paresh,

  We haven’t received any update from the developer as yet but it is developer’s TODO list. We will let you know once the issue is fixed.

  Thanks,
  
  Richa

• 

  paresh-naik

  • Post Options:
  • Link
    Copy

  Posted 10 September 2017, 12:32 pm EST

  Is there a tentative date when this issue will be addressed?

• 

  richas

  • Post Options:
  • Link
    Copy

  Posted 10 September 2017, 12:32 pm EST

  Hello Paresh,

  We have received developer’s reply on the issue. According to him this is the limitation of C1Excel as the file is not OLE Excel format.

  Thanks,
  
  Richa

• 

  mayur.purandare

  • Post Options:
  • Link
    Copy

  Posted 12 November 2018, 11:55 pm EST

  Is there any update on this issue? Or is it still limitation of C1Excel.
  
  My file is in text format.