Skip to main content

IXlSheet Methods

Represents a worksheet in a workbook.
Name Description
BeginFiltering(XlCellRange) Starts filtering data in the specified cell range.
BeginGroup(Boolean) Starts creating a new group in the worksheet.
BeginGroup(Int32, Boolean) Starts creating a new group in the worksheet.
CreateColumn() Creates a new column in the worksheet and returns the IXlColumn object.
CreateColumn(Int32) Creates a new column in the worksheet with the specified index.
CreatePicture() Creates a picture to be inserted into the worksheet.
CreateRow() Creates a new row in the worksheet and returns the IXlRow object.
CreateRow(Int32) Creates a new row in the worksheet with the specified index.
Dispose() Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. Inherited from IDisposable.
EndFiltering() Finishes filtering data in the cell range after calling the IXlSheet.BeginFiltering method.
EndGroup() Finalizes the group creation after calling the IXlSheet.BeginGroup method.
SkipColumns(Int32) Specifies the number of successive columns to be skipped in the worksheet before starting to generate a new column.
SkipRows(Int32) Specifies the number of successive rows to be skipped in the worksheet before starting to generate a new row.
See Also