Page History

{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}

{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