Binding ViewModel to Excel Worksheet

Nov 25, 2013 at 7:45 AM
Is there any functionality in the Excel libraries to bind C# classes (of any kind) to a Excel Workbook/Sheet/Cell?

If so, what sort of binding is possible? E.g. Bind once?...One way binding?....Two way binding?

Nov 25, 2013 at 9:54 AM
its the same as any other. you can bind any class instance for one way binding, also in NetOffice. Two way binding is not supported because the office applications doenst support this. (in a heavy databinding scenario its possible to create you own custom type descriptor or binding list(ITypedList) to imitate two way binding but this means expert knowledge in System.ComponentModel, otherwise you can use one way binding anytime but no two way support )

Nov 25, 2013 at 12:02 PM
I don't suppose you can link me to an example of either.

My google-fu is failing me, all I seem to come up with is binding to a database.

Thanks for the info either way.