Spread impossible to load xls file

Posted by: fsegui on 1 June 2022, 1:48 am EST

  • Posted 1 June 2022, 1:48 am EST

    Hi,
    I'm trying to open an xls file using Spread.Net but it does not work.
    I can sucessfully open xlsx files but not xls.
    Am I missing something?
    ConsoleApp2.zip
  • Replied 1 June 2022, 4:20 pm EST

    Hi,

    We have escalated the issue to the development team to get information regarding this and will let you know as soon as we have an update.

    Regards
    Avnish

    [Tracking ID : SPNET-24443]
  • Replied 1 June 2022, 10:36 pm EST

    Hi Avnish,

    Thanks for your feedback.
    A general question: what's the main differences between Spread.NET & Document for Excel.NET?
  • Replied 2 June 2022, 3:53 pm EST

    Hi Florent,

    Spread.NET for Winforms is the spreadsheet component for use in Windows Forms solutions. With Spread Windows Forms you can develop feature-rich user interfaces with an object-oriented, extensible set of classes to incorporate spreadsheet functionality into your applications. Use Spread Windows Forms to develop front-ends to database applications and give your users access to multiple sheets using many types of cells and predefined sheet styles.
    On the other hand, GrapeCity Documents for Excel, .NET Edition is a small-footprint, high-performance spreadsheet component that can be used in your server or desktop applications. It gives developers a comprehensive API to quickly create, manipulate, convert, and share Microsoft Excel-compatible spreadsheets. Further, you can call it from nearly any application and platform.
    If you need to provide a rich user interface to work on spreadsheet functionalities, you can use Spread but if you only want to quickly create, manipulate, and convert Excel files then you should use GcExcel.

    For the issue reported above, as per the development team, all new features and new APIs work correctly with XLSX only. IWorkbooks.Open won’t be able to open the XLS file. The new API set are APIs that come from IWorkbookSet/IWorkbook/IWorksheet.
    You can use FpSpread.OpenExcel to open the XLS file. However, if XLS file is opened, Spread will go to composite style mode and you won’t be able to use the new API set.
    GcExcel also does not support importing XlS files and as per the development team, there are no plans to support it in the future.

    Regards
    Avnish
  • Replied 2 June 2022, 5:48 pm EST

    Hi Avnish,

    Thanks for your feedback. It's a shame that XLS files are not supported anymore.

    For GcExcel, as we're developping a desktop app that is installed on our customer's computers, what kind of licence would be needed?
    I've checked the pricing: what does mean "Distribution location"? Is it only if we plan to deploy on a webserver (like Azure)?
  • Replied 5 June 2022, 11:16 pm EST

    Hello Florent,

    You can find the details for the GrapeCity Documents Licensing on the below-given link:
    https://www.grapecity.com/documents-api/licensing

    We have also shared your details with our sales team to coordinate with you further accordingly, as they may provide you with better information on this.

    Regards,
    Prabhat Sharma.
Need extra support?

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

Learn More

Forum Channels