Spread com exporting to excel 365

Spread com exporting to excel 365

Posted by: abrahampetit on 9 September 2021, 5:38 am EST

• 

  abrahampetit

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 9 September 2021, 5:38 am EST

  Hi,

  Whenever I try to import an Excel XLSX file with SPREAD8’s “OpenExcel2007File” method on a Windows 10 PC. I get a “false” output with NO LOG whatsoever, This method “OpenExcel2007File” used to work fine with previous versions of Excel, but no with this 365 version.

  Have you ever tested the method “OpenExcel2007File” for Excel 365 files? Is it possible to add importing support to the legacy spread 8.0 on new reviews?

  Thanks!

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 16 September 2021, 11:57 pm EST

  Hello,

  We are discussing your issue with our developers, we will get back to you soon on the same.

  Tracking id for your issue is #SPCOM-8

  Thanks,
  
  Reeva

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 19 September 2021, 6:26 pm EST

  Hello,

  Our developers looked into the issue and said it should work fine to import files created with the latest MS Office 365 Excel version using Spread COM 8, or to save files as XLSX and load those files into MS Office 365 Excel versions. If you are having a problem loading or saving such a file, then we would look into that problem as a bug.

  Please note that the import and export of XLSX files using Spread COM requires .NET 2.0 Framework and setup and registering of the required DLL on the client machine, as described in the redistribution section of the readme here:
  
  https://help.grapecity.com/spread/Spread_COM_ReadMe/webframe.html#redistribution.html

  If the required DLL can’t be loaded in run-time, then the OpenExcel2007File method or SaveExcel2007File method simply fails gracefully and returns false.

  Hope it clarifies and let us know if you have any more doubts.

  Thanks,
  
  Reeva