
		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 > TruncateColumns

TruncateColumns Property

C# Signature:

VB.NET Signature:

Description:

Sets or returns whether imported data columns will be truncated if the number of columns imported exceeds the number of target columns in the spreadsheet.

TruncateColumns is a read / write property.

Examples:

[csharp]

// Get TruncateColumns
bool truncateCols = importProps.TruncateColumns;

// Set TruncateColumns
importProps.TruncateColumns = true;

[vbnet]

' Get TruncateColumns
Dim truncateCols As Boolean = importProps.TruncateColumns

' Set TruncateColumns
importProps.TruncateColumns = True

Getter

Signature:

public            boolean
     TruncateColumns

Returns:

boolean If true, columns will be truncated silently.

Setter

Signature:

public void TruncateColumns                      boolean
     value

Type:

boolean