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

<table class="wysiwyg-macro" data-macro-name="unmigrated-wiki-markup" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e3VubWlncmF0ZWQtd2lraS1tYXJrdXB9&amp;locale=en_GB&amp;version=2); background-repeat: no-repeat;" data-macro-body-type="PLAIN_TEXT"><tr><td class="wysiwyg-macro-body"><pre>
 public boolean TruncateRows{ get; set; }
</pre></td></tr></table>
<p>Public Property TruncateRows() As Boolean</p>

          //--- Get TruncateRows
          bool truncateRows = importProps.TruncateRows;

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

          '--- Get TruncateRows
          Dim truncateRows As Boolean = importProps.TruncateRows

          '--- Set TruncateRows
          importProps.TruncateRows = True