Page History

{description}
{excerpt}Sets or returns the maximum number of rows to be bound to the template file when the [ExcelTemplate.BindData] or [ExcelTemplate.BindColumnData] methods are called.  {excerpt}
{signature:C#}
 public int MaxRows{ get; set; }
{signature}{signature:vb.net}
Public Property MaxRows() As Integer
{signature}
{remarks}
Any rows in the data source after the [MaxRows|DataBindingProperties.MaxRows] value will not be added to the template.

{{MaxRows}} is a *Read/Write* property.

{remarks}
{example}{code:csharp|title=C#}

          DataBindingProperties dbp = xlt.CreateDataBindingProperties();
          dbp.MaxRows = 20;
          xlt.BindData(twodim, names, "TwoDimArray", dbp);
          xlt.Save(Page.Response, "output.xls", false);
        {code}
{code:vb.net|title=vb.net}

          Dim dbp As DataBindingProperties = xlt.CreateDataBindingProperties()
          dbp.MaxRows = 20
          xlt.BindData(twodim, names, "TwoDimArray", dbp)
          xlt.Save(Page.Response, "output.xls", False)
        {code}

{example}