Spreadsheet databinding

[Darryl]

Hi Guys

I was wondering, is it possible to bind a Collection to a Spreadsheet? For eg if I had a collection ObservableCollection<string> MyCollection , I would be able to bind this a GridView like this -> radGridView1.ItemSource = MyCollection;

Is this type of binding possible with the Spreadsheet control?

Thanking you in advance!

Darryl Chetty

[Andrew]

Hello Darryl,

Unfortunately, this is not possible with the current version of RadSpreadsheet. Your scenario sounds much more suitable for the RadGridView control.

At some point we may support adding data from external sources, which is a similar feature, but we have not scheduled it yet.

Regards,
Andrew
the Telerik team

[Edward]

So when I get my data I have to manually set the columns and rows?

[Petya]

Hi Edward,

RadSpreadsheet is designed to allow creation and manipulation of documents, as opposed to other controls in the Telerik UI for WPF suite like RadGridView, which are intended for data-bound scenarios. With this in mind, if you want to populate a workbook with the contents of some collection you would need to assign the values yourself.

Let us know if you have other questions.

Regards,
Petya
Telerik