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
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. = p>=20
public boolean Transpose{ get; set; }=20
Public Property Transpose() As Boolean=20
{{"A","X"},{"B","Y"},{"C"= ,"Z"}}=20
Would be entered in the worksheet as:
=20A | =20
X | =20
B | =20
Y | =20
C | =20
Z | =20
If Transpose is set to true
, the format will be [column]=
[row] and
{{"A","B","C"},{"X","Y",&= quot;Z"}}=20
would be inserted as:
=20A | =20
X | =20
B | =20
Y | =20
C | =20
Z | =20
Transpose is a read/write property.
=20//--- Get Transpose boolean transpose =3D importProps.Transpose; //--- Set Transpose importProps.Transpose =3D true;=20
'--- Get Transpose Dim transpose As Boolean =3D importProps.Transpose '--- Set Transpose importProps.Transpose =3D True=20