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:

Template example:
BindingTemplate

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());
(this code sample comes from the ‘ExcelVsto2010Test’ test project that can be found in the ‘Tests\ExcelVsto2010Test’ subfolder in the solution sources. 

  • Render the view:

ExcelBindingTemplateManager.Instance.Render(View);

  • See the result:

BindingExample

 

Samples :

For more information, please go here

 

To come:

  • User interfaces to make easier the templates creation.
  • Support for all the CRUD operations.
  • More documentation and samples: standard Com Excel Addin, ExcelDna (if i can)...
  • ... 

Last edited Jan 6, 2014 at 8:23 PM by Rbl, version 20