Message-ID: <1905695365.8099.1711631956571.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8098_1520614095.1711631956571" ------=_Part_8098_1520614095.1711631956571 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html DataImportProperties.Transpose

DataImportProperties.Transpose

Description=20

When data is imported from a two-dimensional or rectangular array, the f= irst dimension of the array corresponds to row and the second to column. =20

C#
=20
 public boolean Transpose{ get; set; }
=20
=20
vb.net
=20
Public Property Transpose() As Boolean
=20
=20

Remarks

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

Would be entered in the worksheet as:

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

A

X

B

Y

C

Z

=20

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

=20
=20
{{"A","B","C"},{"X","Y",&=
quot;Z"}}
=20
=20

would be inserted as:

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

A

X

B

Y

C

Z

=20

Transpose is a read/write property.

=20

Examples

=20
C#
=20

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

          //--- Set Transpose
          importProps.Transpose =3D true;
        
=20
=20
vb.net
=20

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

          '--- Set Transpose
          importProps.Transpose =3D True
        
=20
------=_Part_8098_1520614095.1711631956571--