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.

public boolean Truncate{ set; }
Public WriteOnly Property Truncate() As Boolean
          //--- Get Truncate
          bool truncate = importProps.Truncate;

          //--- Set Truncate
          importProps.Truncate = true;
        
          '--- Get Truncate
          Dim truncate As Boolean = importProps.Truncate

          '--- Set Truncate
          importProps.Truncate = True