Where is the DataTableFormatProvider?

1 Answer 251 Views
SpreadProcessing
Tim
Top achievements
Rank 3
Iron
Iron
Iron
Tim asked on 30 Aug 2021, 02:46 PM | edited on 30 Aug 2021, 02:51 PM

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

1 Answer, 1 is accepted

Sort by
1
Accepted
Tanya
Telerik team
answered on 31 Aug 2021, 08:21 AM

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

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Tim
Top achievements
Rank 3
Iron
Iron
Iron
commented on 31 Aug 2021, 10:46 AM | edited

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
Telerik team
commented on 31 Aug 2021, 11:33 AM

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
Top achievements
Rank 3
Iron
Iron
Iron
commented on 31 Aug 2021, 12:50 PM

Thank you!
y2kdis
Top achievements
Rank 1
commented on 28 Feb 2022, 08:42 PM | edited

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
Telerik team
commented on 01 Mar 2022, 03:02 PM

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
Top achievements
Rank 1
commented on 01 Mar 2022, 05:30 PM

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
Telerik team
commented on 02 Mar 2022, 10:07 AM

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.

Tags
SpreadProcessing
Asked by
Tim
Top achievements
Rank 3
Iron
Iron
Iron
Answers by
Tanya
Telerik team
Share this question
or