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.

 public boolean Transpose{ get; set; }
Public Property Transpose() As Boolean
{{"A","X"},{"B","Y"},{"C","Z"}}

Would be entered in the worksheet as:

A

X

B

Y

C

Z

If Transpose is set to true, the format will be [column][row] and

{{"A","B","C"},{"X","Y","Z"}}

would be inserted as:

A

X

B

Y

C

Z

Transpose is a read/write property.


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

          //--- Set Transpose
          importProps.Transpose = true;
        

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

          '--- Set Transpose
          importProps.Transpose = True