/**
* 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.