Excel.SheetVisibility enum

Remarks

API set: ExcelApi 1.1

Used by

• Excel.Worksheet: visibility
• Excel.WorksheetVisibilityChangedEventArgs: visibilityAfter, visibilityBefore

Examples

// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/54-worksheet/worksheet-visibility.yaml

await Excel.run(async (context) => {

 const visibleSheets = await filterWorksheetsByVisibility(context, Excel.SheetVisibility.visible);

 if (visibleSheets.length > 1) {
 console.log(`Hiding worksheet named "${visibleSheets[0].name}"...`);

 visibleSheets[0].visibility = Excel.SheetVisibility.hidden;

 await context.sync();

 } else {
 console.log("Cannot hide the only visible worksheet");
 }
});

Fields