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

Truncate Property

C# Signature:

VB.NET Signature:

Description:

Sets whether ExcelWriter should truncate imported data rows and columns that do not fit within the target rows and columns in the spreadsheet. If Truncate is not enabled, an exception will be thrown if the number of rows or columns imported exceeds the number of target rows or columns in the spreadsheet.

Truncate is a write only property.

Examples:

[csharp]

// Get Truncate
bool truncate = importProps.Truncate;

// Set Truncate
importProps.Truncate = true;

[vbnet]

' Get Truncate
Dim truncate As Boolean = importProps.Truncate

' Set Truncate
importProps.Truncate = True

Setter

Signature:

public void Truncate                      boolean
     value

Type:

boolean