C1Excel in .NET6

C1Excel in .NET6

Posted by: wknauf on 9 August 2022, 10:29 am EST

• 

  wknauf

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 9 August 2022, 10:29 am EST

  Hi C1,

  just planning migration of our app to .NET6, and the last C1 component where I could not find a .NET6 version is “C1.C1Excel.4.5.2.dll”.

  In a sample app, this file worked in a .NET6 environment. But looking at the dependencies, I fear this is not a good idea.

  What about “GrapeCity.Documents.Excel”, which can be found in the bin folder of my sample app and is probably pulled by C1FlexGrid or "C1.Win.FlexGrid.ImportExport? Is this the suggested replacement? But probably totally different API and not part of a WinForms license?

  Best regards

  Wolfgang

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 10 August 2022, 12:28 am EST - Updated 12 December 2022, 4:46 am EST

  Hi Wolfgang,

  The C1Excel library is not yet migrated to .NET6. Although, it is planned to be migrated to .NET6 in the 2022v3 release.

  The GrapeCity.Documents.Excel (also known as GcExcel) is a more advanced and rich API that is now used in the backend of our .NET6 controls (including the C1FlexGrid with C1.Win.FlexGrid.ImportExport package) for Excel import/export and other features.

  Yes, you are correct that the GcExcel comes under a different product line (known as Document APIs) and is not a part of a WinForms license. You can refer to the links below for more information related to GcExcel.

  (https://www.grapecity.com/documents-api)

  (https://www.grapecity.com/documents-api-excel)

  Best Regards,
  
  Kartik

• 

  wknauf

  • Post Options:
  • Link
    Copy

  Posted 10 August 2022, 2:21 am EST

  Hi Kartik,

  that’s bad news, but I hope it is not a blocker for us. We have already licensed an Excel library from another company, so we would have to switch all usages of C1Excel to this one.

  Best regards
  
  Wolfgang

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 18 August 2022, 3:14 am EST

  Hi Wolfgang,

  Apologies for the inconvenience caused to you. We just confirmed with the development team that the C1Excel (for .NET6) is on their to-do list and it is targeted for the 2022v3 release.

  Kind Regards,
  
  Kartik

• 

  wknauf

  • Post Options:
  • Link
    Copy

  Posted 8 December 2022, 10:51 am EST

  Hi,

  I assume it did not make it into 2022v3?

  Best regards

  Wolfgang

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 9 December 2022, 12:39 am EST

  Hi Wolfgang,

  The 2022v3 release includes a .NET Standard-based version of the C1Excel library.
  
  You can install the latest 2.0.20223.7 version of the C1.Excel Nuget package. https://www.nuget.org/packages/C1.Excel/2.0.20223.7

  If you face any issues, let us know.

  Regards
  
  Avnish

• 

  wknauf

  • Post Options:
  • Link
    Copy

  Posted 9 December 2022, 4:32 am EST

  OK, thanks.

  I did not notice it because of two problems:
  
  a) this package is not installed as part of the C1 WinForms installation (“C:\Program Files (x86)\ComponentOne\WinForms Edition\bin\v6”).
  
  b) the versioning of the package is problematic, because the number “2.0.20223.7” is older than the 4.5 versions from 2019. So I assume that when installing this package, there will always be an “Update available” notification.

  One additional detail: the C1.Excel dll does not have the “CLSCompliant” attribute, so it will result in warnings if used in DLLs that are “CLSCompliant”.

  Best regards

  Wolfgang

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 12 December 2022, 9:20 am EST

  Hi Wolfgang,

  We have shared your observations with the product team and the development team to get their insights on it. We will let you know the updates as soon as possible.

  [Internal Tracking ID: C1WIN-28758]

  Best Regards,

  Kartik

• 

  wknauf

  • Post Options:
  • Link
    Copy

  Posted 5 January 2023, 12:19 pm EST

  Seems the version problem is fixed, as I see a new version “5.0.20223.11” in Nuget.
  
  Still the question why it does not match the C1WinForms version?

  Best regards
  
  Wolfgang

• 

  kartik.dua

  

  • Post Options:
  • Link
    Copy

  Posted 6 January 2023, 5:26 am EST

  Hi Wolfgang,

  The C1.Excel library is built on .NET Standard and is intended for use across multiple platforms. It is not only linked to WinForms, and thus they do not share the same versioning.

  In addition, the “CLSCompliant” attribute has been added to the latest DLL.

  Best Regards,

  Kartik