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.

Signature

	C#
	C#

 public boolean Transpose{ get; set; }

Signature

	vb.net
	vb.net

Public Property Transpose() As Boolean

Remarks

Code Block

	csharp
	csharp

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

Code Block

	csharp
	csharp

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

would be inserted as:

A	X
B	Y
C	Z

Transpose is a read/write property.

Example

Code Block

	csharp
	csharp
title	C#


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

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

Code Block

	vb.net
	vb.net
title	vb.net


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

          '--- Set Transpose
          importProps.Transpose = True

Space Shortcuts

Page tree

Versions Compared

Old Version 7

New Version Current

Key