Page History

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

          //--- Get Truncate
          bool truncate = importProps.Truncate;

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

          '--- Get Truncate
          Dim truncate As Boolean = importProps.Truncate

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

{example}