通过

Excel.SheetVisibility enum

  • 参考
包:
excel

注解

[ API 集：ExcelApi 1.1 ]

示例

// 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");
    }
});

字段

hidden = "Hidden"
veryHidden = "VeryHidden"
visible = "Visible"