HotXLS 文件

Pattern 屬性

傳回或設定內部圖樣。可讀寫 LongWord

語法

property Pattern: LongWord;

說明

Pattern can be one of these XlPattern constants
xlPatternAutomatic
xlPatternChecker
xlPatternCrissCross
xlPatternDown
xlpatterngray16
xlpatterngray25
xlpatterngray50
xlpatterngray75
xlpatterngray8
xlPatternGrid
xlPatternHorizontal
xlPatternLightDown
xlPatternLightHorizontal
xlPatternLightUp
xlPatternLightVertical
xlPatternNone
xlPatternSemiGray75
xlPatternSolid
xlPatternUp
xlPatternVertical

範例

此範例在工作表一的 A1 儲存格內部新增交叉線圖樣

Workbook.Worksheets[1].Range['A1', 'A1'].Interior.Pattern := xlPatternCrissCross;