The span model includes the objects needed to handle cell spans and automatic merging of cells. Refer to the Cell class, ColumnSpan and RowSpan properties.

To use the underlying span model, use the Add, Clear, and Remove methods of the span model. Refer to the Assembly Reference for more information on the axis model in general and to the DefaultSheetSpanModel methods in particular.

The default implementation of the span model (DefaultSheetSpanModel) uses an array to stored the cell spans. If there are a modest number of spans in the sheet (for example, a thousand or less) then the default implementation works fine. If there are a very large number of spans in the sheet (for example, a hundred thousand or more) then the default implementation slows dramatically.

In scenarios where you have a very large number of spans that repeat on a regular interval, you should consider writing a custom span model. By writing a custom span model, you can significantly increase the speed and decrease the memory usage.

Return to the overview of Finding More Details on the Sheet Models.