Working with files containing Threaded Comments

1 Answer 90 Views
SpreadProcessing
Renier Pretorius
Top achievements
Rank 1
Iron
Iron
Iron
Renier Pretorius asked on 02 Jun 2022, 04:02 PM

Hi,

I am using the SpreadsheetProcessing library to import Excel files for reading data. I am sure there are other libs to use as well but as a long-time Telerik customer this was a very easy and neat way for me to import xlsx files without the need for any interops. Worked like a charm until i got a source file that contains Threaded Comments (Office365) which throws an exception on import.

I see that working with Threaded Comments are currently in development for 2022 R2 but is there a way to "ignore" them so not to throw an exception in import. I am not interested in the comments.

Thanks

1 Answer, 1 is accepted

Sort by
0
Dimitar
Telerik team
answered on 03 Jun 2022, 07:11 AM

Hello Renier,

There is no way to skip the comments on import. Indeed they are supported in the last version and a lot of issues were fixed. This is why I would suggest trying this with the latest version. If there is still an exception I would recommend posting a ticket and attaching your file there (the ticket is a private thread). This way we will be able to investigate this and determine what is causing the exception.

Thank you in advance for your patience and cooperation. 

Regards,
Dimitar
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Renier Pretorius
Top achievements
Rank 1
Iron
Iron
Iron
commented on 03 Jun 2022, 07:27 AM

Hi Dimitar,

I actually did not explicitly add any references to the spreadsheet processing libraries in my project, I just added the Telerik.UI.for.Wpf.60 nuget package. Based on your comment I have now explicitly also added the Telerik.Documents.Spreadsheet.FormatProviders.OpenXml package. However the compiler now gives me a version conflict error between 2022.2.428.20 and 2022.2.428.60.

My project is .NET6

Dimitar
Telerik team
commented on 03 Jun 2022, 09:16 AM

Hi Reiner,

The assemblies are already added to the Telerik.UI.for.Wpf.60 package. You can see that by expanding the package in Visual Studio (see attached). There is no need to add them separately. 

Tags
SpreadProcessing
Asked by
Renier Pretorius
Top achievements
Rank 1
Iron
Iron
Iron
Answers by
Dimitar
Telerik team
Share this question
or