Excel for WinRT
XLSheet Class Properties

For a list of all members of this type, see XLSheet members.

Public Properties
 NameDescription
Public PropertyBookGets a reference to the C1XLBook that owns the sheet.  
Public PropertyColumnMaxLevelGets maximum outline level for columns.  
Public PropertyColumnsGets a reference to sheet's column collection.  
Public PropertyCommentsGets an XLCommentCollection that contains the collection of comments that on the sheet.  
Public PropertyConditionalFormattingsGets the collection of XLConditionalFormatting objects for the current workbook.  
Public PropertyDefaultColumnWidthGets or sets the default column width for the sheet (in twips).  
Public PropertyDefaultRowHeightGets or sets the default row height for the sheet (in twips).  
Public PropertyGridColorGets or sets the color used to display gridlines.  
Public PropertyItemGets the cell at a specified position on the sheet, creating a new cell if necessary.  
Public PropertyLockedGets or sets a value that determines if the sheet is locked for editing.  
Public PropertyMaxOutlineLevelGets the maximum subtotals outline level for rows or columns.  
Public PropertyMergedCellsGets an XLCellRangeCollection that contains the collection of cells that are merged on the sheet.  
Public PropertyNameGets or sets the name of the XLSheet.  
Public PropertyOutlinesBelowGets or sets a value indicating the vertical location of outline buttons.  
Public PropertyOutlinesRightGets or sets a value indicating the horizontal location of outline buttons.  
Public PropertyPrintSettingsGets or sets an XLPrintSettings object that controls how the sheet is printed.  
Public PropertyRowMaxLevelGets maximum outline level for rows.  
Public PropertyRowsGets a reference to the sheet's row collection.  
Public PropertyScaleGets or sets the view scale of this worksheet using percentages.  
Public PropertySelectedCellsGets an XLCellRangeCollection that contains the collection of cells that are selected on the sheet.  
Public PropertyShapesGets a reference to the ShapeCollection for the sheet.  
Public PropertyShowGridLinesGets or sets whether Excel should show the grid lines when displaying the sheet.  
Public PropertyShowHeadersGets or sets whether Excel should show the row and column headers when displaying the sheet.  
Public PropertyShowZerosGets or sets whether Excel should show the zero values on the sheet.  
Public PropertyTabColorGets or sets the color used to display the tab of this sheet.  
Public PropertyTotalsBelowDataGets whether Excel should show the subtotals data when displaying the sheet.  
Public PropertyVisibleGets or sets the sheet's visibility.  
Top
See Also

Reference

XLSheet Class
C1.Xaml.Excel Namespace

 

 


Copyright (c) GrapeCity, inc. All rights reserved.

Product Support Forum  |  Documentation Feedback