HotXLS Docs
Home Contents Overview

TXLSWorksheet class

Unit: lxHandle
Represents a Worksheet. The Worksheet object is a member of the Worksheets collection. The Worksheets collection contains all the Worksheet objects in a Workbook

Properties

Cells property
Selection property
PageSetup property
Range property
RCRange property
UsedRange property
Name property
Names property
Index property
Next property
Previous property
HPageBreaks property
VPageBreaks property
DisplayGridLines property
GridlineColorIndex property
DisplayFormulas property
DisplayHeadings property
DisplayOutlineSymbols property
DisplayZeros property
DisplayRightToLeft property
ScrollRow property
ScrollColumn property
Zoom property
PageBreakPreviewZoom property
NormalViewZoom property
View property
Selected property
StandardHeight property
StandardWidth property
Hyperlinks property
Shapes property
Visible property
Outline property
IsProtected property
Protection permission properties
AutoFilterRange property
AutoFilterColumns property

Methods

Calculate method
AddListValidation method
Typed data-validation methods
AddHyperlink method
AddComment method
AddTextBox method
Add shape methods
SetAutoFilter method
ApplyAutoFilter method
ForEachCell method
FindText method
ReplaceText method
WriteCells method
Range operation methods
ClearAutoFilter method
Delete method
Move method
SaveAs method
SaveAsCSV method
Select method
SelectAreas method
Add page break methods
ResetAllPageBreaks method
Activate method
FreezePanes method
Pane and print-title methods
Pivot table members
Protect method
UnProtect method
SaveAsHTML method
SaveAsRTF method