GrapeCity.Documents.Excel.InsufficientSpaceHandling

InsufficientSpaceHandling Enum

Specifies how insufficient destination space is handled when importing data into a range.

Use this enum with InsufficientSpaceHandling to control whether incoming data overwrites existing cells, inserts cells to make room, or is truncated when the target range cannot accommodate the full import. The default behavior is Overwrite.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum InsufficientSpaceHandling

Public Enum InsufficientSpaceHandling

Examples

worksheet.Range["A5"].Value = "Existing data";
DataImportOptions options = new DataImportOptions();
options.SetInsufficientSpaceHandling(InsufficientSpaceHandling.InsertCells);
worksheet.Range["A1:A4"].ImportData(new double[] {1.0, 2.0, 3.0, 4.0, 5.0}, options);

Fields

Name	Description
InsertCells	Insert cells to make space.
Overwrite	Overwrite cells outside of the bounds. This is the default behavior.
Truncate	Do not spill data or expand range.