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 |
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
Office Scripts