
		Forums Knowledge Base OfficeWriter Online


	This documentation is for OfficeWriter v3.0.4 .NET Platform View Docs for Another Version or Platform

Programmer's Reference > ExcelApplication API > DataImportProperties > Transpose

Transpose Property

C# Signature:

VB.NET Signature:

Description:

When data is imported from a two-dimensional or rectangular array, the first dimension of the array corresponds to column and the second to row. Thus, the array {{"A","B","C"},{"X","Y",Z"}} would be entered in the worksheet as:

A	X
B	Y
C	Z

If Transpose is set to true , the format will be [row][column] and the same array would be inserted as:

    A   B   C  
   X   Y   Z  
  
 
  Transpose is a 
  read / write property.

Examples:

[csharp]

// Get Transpose
boolean transpose = importProps.Transpose;

// Set Transpose
importProps.Transpose = true;

[vbnet]

' Get Transpose
Dim transpose As Boolean = importProps.Transpose

' Set Transpose
importProps.Transpose = True

Getter

Signature:

public            boolean
     Transpose

Returns:

boolean If true, the first dimension of a two-dimensional or rectangular array imported to the worksheet will be considered columns, and the second rows.

Setter

Signature:

public void Transpose                      boolean
     value

Type:

boolean