Sets or returns whether the data being bound to a template file should be transposed before being bound to the template using the ExcelTemplate.BindData method.

 public boolean Transpose{ get; set; }
Public Property Transpose() As Boolean

If this property is set to true, the rows and columns of the data source will be flipped so that the first row of data is inserted in the first column, the second row of data into the second column, and so on. The default value for this property is false.

Transpose is a Read/Write property.


          DataBindingProperties dbp = xlt.CreateDataBindingProperties();
          dbp.Transpose = true;
          xlt.BindData(twodim, names, "TwoDimArray", dbp);
          xlt.Save(Page.Response, "output.xls", false);
        

          Dim dbp As DataBindingProperties = xlt.CreateDataBindingProperties()
          dbp.Transpose = False
          xlt.BindData(twodim, names, "TwoDimArray", dbp)
          xlt.Save(Page.Response, "output.xls", False)