ExcelScript.BuiltInStyle enum
Comentários
Exemplos
/**
* This script sets the cell style to "warning text"
* on every cell with a formula error.
*/
function main(workbook: ExcelScript.Workbook) {
// Get the used range in the current worksheet.
const sheet = workbook.getActiveWorksheet();
const usedRange = sheet.getUsedRange();
// Get any cells that are displaying errors.
const errorCells = usedRange.getSpecialCells(
ExcelScript.SpecialCellType.formulas,
ExcelScript.SpecialCellValueType.errors
);
// Check if there are error cells before proceeding.
if (errorCells) {
// Use the built-in warning text style on the error cells.
errorCells.setPredefinedCellStyle(
ExcelScript.BuiltInStyle.warningText.toString()
);
} else {
console.log("No formula errors in the worksheet.");
}
}
Campos
accent1 | |
accent1_20 | |
accent1_40 | |
accent1_60 | |
accent2 | |
accent2_20 | |
accent2_40 | |
accent2_60 | |
accent3 | |
accent3_20 | |
accent3_40 | |
accent3_60 | |
accent4 | |
accent4_20 | |
accent4_40 | |
accent4_60 | |
accent5 | |
accent5_20 | |
accent5_40 | |
accent5_60 | |
accent6 | |
accent6_20 | |
accent6_40 | |
accent6_60 | |
bad | |
calculation | |
checkCell | |
comma | |
currency | |
emphasis1 | |
emphasis2 | |
emphasis3 | |
explanatoryText | |
good | |
heading1 | |
heading2 | |
heading3 | |
heading4 | |
hlink | |
hlinkTrav | |
input | |
linkedCell | |
neutral | |
normal | |
note | |
output | |
percent | |
sheetTitle | |
total | |
warningText | |
wholeComma | |
wholeDollar |
Colaborar conosco no GitHub
A fonte deste conteúdo pode ser encontrada no GitHub, onde você também pode criar e revisar problemas e solicitações de pull. Para obter mais informações, confira o nosso guia para colaboradores.