HotXLS Docs
Home Contents Overview

TXLSWorksheet 类

Unit: lxHandle
表示一个工作表。Worksheet 对象是 Worksheets 集合的成员。该集合包含工作簿中的所有 Worksheet 对象

属性

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
保护权限属性
AutoFilterRange property
AutoFilterColumns property

方法

Calculate method
AddListValidation method
类型化数据有效性验证方法
大纲节点查询与控制方法
AddHyperlink method
AddComment method
AddTextBox 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
窗格与打印标题方法
Pivot table 成员
Protect method
UnProtect method
SaveAsHTML method
SaveAsRTF method