Where is the DataTableFormatProvider?

[Tim]

I'm trying to convert a DataTable to a spreadsheet.

According to the documentation:

To use the DataTableFormatProvider you need to reference the Telerik.Windows.Documents.Spreadsheet assembly.

After adding a reference to this assembly, Visual Studio still does not recognize it. Where can I find the DataTableFormatProvider?

Thanks,

Tim

[Tanya]

Hi Tim,

Once the assembly is referenced, Visual Studio should be able to detect the class and resolve its namespace. The DataTableFormatProvider resides inside the Telerik.Windows.Documents.Spreadsheet.FormatProviders namespace. Can you please verify that there is a using for it? The class has been added with the latest official release (R2 2021), so please ensure that the version you are using is up to date.

Regards,
Tanya
Progress Telerik

[Tim]

I was referencing an older version. Once I updated to the latest it works.

In the Telerik UI for WinForms R2 2021 folder, what's the difference between Bin40, Bin50, and Bin60? I searched the documentation but couldn't find anything.

Thanks,

Tim

[Tanya]

Hi Tim,

The folders contain assemblies built for the different .NET versions. You can choose between them depending on the version the project is targeting. More information on that topic is available in the Assembly Version article.

[Tim]

Thank you!

[y2kdis]

Hi Tanya,

I have the same issue. I can't locate the DataTableFormatProvider class even though I have the Telerik.Windows.Documents.Spreadsheet assembly installed and referenced in my project. I have version 2021.1.322 which I downloaded (along with Documents.Core, FormatProviders.OpenXml, FormatProviders.Xls , and Zip) via NuGet.

I also verified that there's no conflicting older version installed on my machine.

Any clue?

Thanks,

Sid

 

[Tanya]

Hi Sid,

The DataTableFormatProvider class has been introduced in the next release (R2 2021), and you will need to update the binaries to a newer version if you would like to use this functionality.

Hope this is helpful.

[y2kdis]

When will this R2 2021  be available in the NuGet repository? The 2021.1.322 version is the latest build available there.

Thanks,

Sid

[Tanya]

Hi Sid,

The binaries are already available on NuGet. A possible reason for not seeing them is if your license is expired - new versions are available during the license period only. If you would like to renew your license, you can do so from your account (https://www.telerik.com/account/your-licenses).

Hope this helps.