ExcelScript.FillPattern enum
Remarks
Examples
/**
* This script sets a black-checkered fill on the selected range.
*/
function main(workbook: ExcelScript.Workbook) {
const selected = workbook.getSelectedRange();
selected.getFormat().getFill().setPattern(ExcelScript.FillPattern.checker);
selected.getFormat().getFill().setPatternColor("black");
}
Fields
| checker | |
| crissCross | |
| down | |
| gray16 | |
| gray25 | |
| gray50 | |
| gray75 | |
| gray8 | |
| grid | |
| horizontal | |
| lightDown | |
| lightHorizontal | |
| lightUp | |
| lightVertical | |
| linearGradient | |
| none | |
| rectangularGradient | |
| semiGray75 | |
| solid | |
| up | |
| vertical |