Page History

{description}
{excerpt}When data is imported from a two\-dimensional or rectangular array, the first dimension of the array corresponds to row and the second to column. {excerpt}
{signature:C#}
 public boolean Transpose{ get; set; }
{signature}{signature:vb.net}
Public Property Transpose() As Boolean
{signature}
{remarks}
{code:csharp}
{{"A","X"},{"B","Y"},{"C","Z"}}
{code}
Would be entered in the worksheet as:
|A|X|
|B|Y|
|C|Z|
If [Transpose|DataImportProperties.Transpose] is set to {{true}}, the format will be \[column\]\[row\] and  
{code:csharp}
{{"A","B","C"},{"X","Y","Z"}}
{code} would be inserted as:
|A|X|
|B|Y|
|C|Z|
Transpose is a read/write property.

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

          //--- Get Transpose
          boolean transpose = importProps.Transpose;

          //--- Set Transpose
          importProps.Transpose = true;
        {code}
{code:vb.net|title=vb.net}

          '--- Get Transpose
          Dim transpose As Boolean = importProps.Transpose

          '--- Set Transpose
          importProps.Transpose = True
        {code}

{example}