Project Description
Enables to bind your .Net class instances in your Excel documents via templates.
Binding are bi-directional (changes in Excel will affect underlying objects).
Introduction:
Inspired by Microsoft WPF, the goal of this application is to bind and render your data objects in Excel directly.
As its (much bigger) model, this project relies on templates (the ‘.xaml’ in WPF) to render your data.
In ‘Excel To Object Binder’, the templates are built directly in Excel according to a certain formalism (for more information please go here).
As WPF, if you data model (or your view model for the Mvvm addicts) supports the ‘INotifyPropertyChanged’ interface, the views will be refreshed according to you data changes (some examples here) (if not, your data will be refreshed when requested or when a sheet is activated).
As WPF, the Binding is bi-directional.
A quick overview of how to proceed:
Excel.Range viewFirstOutputRange = this.Range["B3", missing];
IExcelTemplateView view = ExcelBindingTemplateManager.Instance.AddView("Template Customer 1", "Customers1", this.InnerObject, viewFirstOutputRange);(this code sample comes from the ‘ExcelVsto2010Test’ test project that can be found in the ‘Tests\ExcelVsto2010Test’ subfolder in the solution sources.
view.SetDataSource(CustomersManager.GetCustomers());
ExcelBindingTemplateManager.Instance.Render(View);
Samples :
For more information, please go here.
To come: