Page History

{description}
{excerpt}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.{excerpt}
{signature:C#}
 public boolean TruncateRows{ get; set; }
{signature}{signature:vb.net}
Public Property TruncateRows() As Boolean
{signature}
{example}{code:csharp|title=C#}

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

          //--- Set TruncateRows
          importProps.TruncateRows = true;
        {code}
{code:vb.net|title=vb.net}

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

          '--- Set TruncateRows
          importProps.TruncateRows = True
        {code}

{example}