Example |
---|
Code Block |
---|
| csharp | csharp |
title | C# |
---|
{exception}
{exception:ArgumentException}
{exception}
{remarks}A {{DataBindingProperties}} object is required for each data binding call, including these methods: [BindData|ExcelTemplate.BindData], [BindCellData|ExcelTemplate.BindCellData(Object, String, DataBindingProperties)], [BindColumnData|ExcelTemplate.BindColumnData], and [BindRowData|ExcelTemplate.BindRowData]. Hence, [CreateDataBindingProperties|ExcelTemplate.CreateDataBindingProperties()] must be called at least once in any WordTemplate project that binds data to a template.
The same {{DataBindingProperties}} object can be used for multiple data binding method calls.
{remarks}
{example}{code:csharp|title=C#}
//--- Create a DataBindingProperties object to be used
//--- in a data binding call
DataBindingProperties dbp = ExcelTemplate.CreateDataBindingProperties();
dbp.MaxRows = 20;
xlt.BindData(twodim, names, "TwoDimArray", dbp);
xlt.Process();
xlt.Save(Page.Response, "output.xls", false);
Code Block |
---|
{code}
{code:vb.net
vb.net | title | |title=vb.net
}
'--- Create a DataBindingProperties object to be used
'--- multiple times in a project
Dim dbp As DataBindingProperties = ExcelTemplate.CreateDataBindingProperties()
dbp.MaxRows = 20
xlt.BindData(twodim, names, "TwoDimArray", dbp)
xlt.Process()
xlt.Save(Page.Response, "output.xls", False)
{code}
{example}