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.