ComponentOne Excel for .NET
C1.Excel Assembly / C1.Excel Namespace / XLSheet Class
Properties Methods

In This Topic
    XLSheet Class Members
    In This Topic

    The following tables list the members exposed by XLSheet.

    Public Properties
     NameDescription
    Public PropertyGets or sets the background bitmap (image) of the XLSheet.  
    Public PropertyGets a reference to the C1XLBook that owns the sheet.  
    Public PropertyGets or sets the code name of the XLSheet. Is need for VBA operations.  
    Public PropertyGets maximum outline level for columns.  
    Public PropertyGets a reference to sheet's column collection.  
    Public PropertyGets an XLCommentCollection that contains the collection of comments that on the sheet.  
    Public PropertyGets the collection of XLConditionalFormatting objects for the current workbook.  
    Public PropertyGets the collection of XLDataValidation objects for the current workbook.  
    Public PropertyGets or sets the default column width for the sheet (in twips).  
    Public PropertyGets or sets the default row height for the sheet (in twips).  
    Public PropertyGets or sets the color used to display grid lines.  
    Public PropertyGets the cell at a specified position on the sheet, creating a new cell if necessary.  
    Public PropertyGets or sets a value that determines if the sheet is locked for editing.  
    Public PropertyGets the maximum subtotals outline level for rows or columns.  
    Public PropertyGets an XLCellRangeCollection that contains the collection of cells that are merged on the sheet.  
    Public PropertyGets or sets the name of the XLSheet.  
    Public PropertyGets or sets a value indicating the vertical location of outline buttons.  
    Public PropertyGets or sets a value indicating the horizontal location of outline buttons.  
    Public PropertyGets or sets whether Excel should show page break preview when displaying the sheet.  
    Public PropertyGets or sets an XLPrintSettings object that controls how the sheet is printed.  
    Public PropertyGets maximum outline level for rows.  
    Public PropertyGets a reference to the sheet's row collection.  
    Public PropertyGets or sets the view scale of this worksheet using percentages.  
    Public PropertyGets or sets the view scale for normal view of this worksheet using percentages.  
    Public PropertyGets an XLCellRangeCollection that contains the collection of cells that are selected on the sheet.  
    Public PropertyGets a reference to the ShapeCollection for the sheet.  
    Public PropertyGets or sets whether Excel should show the grid lines when displaying the sheet.  
    Public PropertyGets or sets whether Excel should show the row and column headers when displaying the sheet.  
    Public PropertyGets or sets whether Excel should show the zero values on the sheet.  
    Public PropertyGets or sets the color used to display the tab of this sheet.  
    Public PropertyGets whether Excel should show the subtotals data when displaying the sheet.  
    Public PropertyGets or sets whether Excel should show view layout (preview) when displaying the sheet.  
    Public PropertyGets or sets the sheet's visibility.  
    Top
    Public Methods
     NameDescription
    Public MethodCreates a copy of this sheet.  
    Public MethodCopies the formula from a source cell to a destination cell, adjusting relative references.  
    Public MethodGets a reference to a cell at the specified coordinates or null if the cell doesn't exist.  
    Public MethodGets formatted text is using XLStyle format value of the cell.  
    Public MethodReturns a value indicating whether print titles are specified for this worksheet. (Print titles are rows repeated at top, and columns repeated at left of each page when the sheet is printed.) Output parameters indicate the indexes of title rows and columns.  
    Public MethodOverloaded. Loads the Excel worksheet from a file.  
    Public MethodOverloaded. Loads data from a file containing comma-separated values (.csv) into the current sheet.  
    Public MethodOverloaded. Saves data from the current sheet into a comma-separated values (.csv) formatted file.  
    Public MethodSpecifies the range of rows or/and columns to use as print titles for this worksheet. (Print titles are rows repeated at top, and columns repeated at left of each page when the sheet is printed.)  
    Top
    See Also