天软金融分析.NET函数大全
>
文档处理函数
>
Excel处理函数
>
Excel操作相关的类
>
TxlsSheet类
>
TxlsSheet方法
IsDateTime
复制链接
简述
指定单元格是否为时间日期格式。
定义
IsDateTime(Col:Integer;Row:Integer): boolean;
参数
名称
类型
说明
Col
Integer
整数,列的位置,从0开始。
Row
Integer
整数,行的位置,从0开始。
返回
boolean
布尔类型
范例
obj:=CreateObject("txlsreadwrite");
filename:="E:\\TestExcel\\TslRW01.xlsx";
obj.LoadFromFile("",filename);
mysheet:=obj.sheets("Sheet5");
return mysheet.IsDateTime(3,4);
返回:1
原excel:
相关
AsString
AsRichText
AsFmtString
AsHyperlink
AsHTML
AsStringW
AsRichTextW
AsFmtStringW
AsHyperlinkW
AsHTMLW
AsBoolean
AsError
Value
ValueW
AsEmpty
AsFormula
AsFormulaW
AsNumFormulaValue
AsStrFormulaValue
AsStrFormulaValueW
AsBoolFormulaValue
IsDateTime
IsError
CellType
FormulaType
Protection
HorizAlignment
VertAlignment
Indent
Rotation
WrapText
ShrinkToFit
FillPatternForeColor
FillPatternBackColor
FillPatternPattern
NumberFormat
NumberFormatW
BorderTopColor
BorderTopStyle
BorderLeftColor
BorderLeftStyle
BorderRightColor
BorderRightStyle
BorderBottomColor
BorderBottomStyle
BorderDiagColor
BorderDiagStyle
FontName
FontNameW
FontFamily
FontColor
FontSize
FontStyle
FontSubSuperScript
FontUnderline
FillPatternForeColorRGB
FillPatternBackColorRGB
BorderTopColorRGB
BorderLeftColorRGB
BorderRightColorRGB
BorderBottomColorRGB
BorderDiagColorRGB
CellColorRGB
Values
ValuesW
AsBlank
AsInteger
AsFloat
AsDateTime
Comment
CommentW
RowHeight
RowHide
ColWidth
ColHide
MergedCells
HasComment
DeleteComment
MergeCells
UnMergeCells
Clear
AutoWidthCol
AutoHeightRow
UnfreezePanes
FreezePanes
UnsplitPanes
SplitPanes
Calculate
CalculateW
CopyCell
CopyCells
DeleteCell
DeleteCells
MoveCell
MoveCells
DeleteRows
ClearRows
InsertRows
CopyRows
MoveRows
DeleteColumns
ClearColumns
InsertColumns
CopyColumns
MoveColumns
IsEmpty
Sort
GroupRows
GroupColumns
UngroupRows
UngroupColumns
FindCell
MakeHyperlink
CalcDimensionsEx
FirstCol
LastCol
FirstRow
LastRow
SetDefaultFormat
IsFormatted