Worksheet topic
Worksheet-level features: hyperlinks, data validation, conditional formatting, filters, freeze and split panes, comments, sparklines, sheet and workbook protection, row and column grouping, and page setup.
Classes
- Comment Worksheet
- A classic cell comment (note), the little pop-up box anchored to a cell.
- ConditionalFormat Worksheet
- A conditional formatting rule applied to a cell range.
- DataValidation Worksheet
- An input rule applied to a cell range: a dropdown list, a numeric/length bound, a date/time constraint, or a custom formula.
- ExcelImage Worksheet
- A picture embedded in a worksheet.
- FilterColumn Worksheet
- A criterion applied to one column of a sheet's autofilter, the filter that actually hides non-matching rows, beyond just showing the dropdown arrow.
- Hyperlink Worksheet
- A hyperlink attached to a cell (or cell range).
- PageMargins Worksheet
-
Printed page margins, in inches (the unit used by
<pageMargins>). - PageSetup Worksheet
- How a worksheet is laid out for printing: orientation, scaling, centering, what to print, and page margins.
- Sparkline Worksheet
- A single sparkline: a tiny chart of dataRange drawn inside the cell at location.
- SparklineGroup Worksheet
- A group of Sparklines that share one type and colour scheme, the unit Excel stores sparklines in.
Enums
- ConditionalFormatType Worksheet
-
The kind of a ConditionalFormat rule. Covers the common OOXML
cfRuletypes; anything else reads as other (its raw type is on ConditionalFormat.typeName). - IconSetType Worksheet
- The icon set drawn by ConditionalFormat.iconSet. The name encodes the icon count (three / four / five icons).
- SheetProtectionOption Worksheet
- An action a user may be permitted to perform on a protected sheet.
- SheetVisibility Worksheet
- Visibility of a worksheet's tab within the workbook.
- SparklineType Worksheet
- The kind of miniature chart drawn by a SparklineGroup.