HotXLS Docs
Home Contents Overview

IXLSWorksheet 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
AddHyperlink method
SetAutoFilter method
ApplyAutoFilter method
ForEachCell method
FindText method
ReplaceText method
WriteCells method
ClearAutoFilter method
Delete method
Move method
SaveAs method
SaveAsCSV method
Select method
SelectAreas method
ResetAllPageBreaks method
Activate method
FreezePanes method
Protect method
UnProtect method
SaveAsHTML method
SaveAsRTF method