SPREAD COM EXPORTING TO EXCEL 365

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

  • 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!
  • Replied 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
  • Marked as Answer

    Replied 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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels