TxtLoadOptions.ExtendToNextSheet

TxtLoadOptions.ExtendToNextSheet property

Whether extends data to next sheet when the rows or columns of data exceed limit. Default is false.

public bool ExtendToNextSheet { get; set; }

Remarks

If this property is true, extra data will be put into next sheet behind current one (if current sheet is the last one, new sheet will be appended to current workbook). If this property is false, the data exceeding limit will be ignored.

See Also