Excel close is not working about office-js

[shanshanzheng-dev]

Hi @ishanig11 Thanks for reporting this issue. I run this code and context workbook is getting closed. Could you please try again? Thanks.
async function run() {
await Excel.run(async (context) => {
context.workbook.close(Excel.CloseBehavior.skipSave);
await context.sync();
});
}

[ishanig11]

@shanshanzheng-dev : I am using similar code but for me no error no message. Also my action button is present under task pane.
Is it possible for you to share this sample application? And also video of behavior?

[shanshanzheng-dev]

Hi @ishanig11, I use script lab to run this code, you can check this video:

Screen.Recording.2024-06-17.at.07.41.08.mov

[ishanig11]

I used same code from function getting called in executeFunction. But not working.

[shanshanzheng-dev]

Hi @ishanig11 This is my Excel online build number: 16.0.17809.42308. And this is my test code on script lab:
$("#run").on("click", () => tryCatch(run));

async function run() {
await Excel.run(async (context) => {
context.workbook.close(Excel.CloseBehavior.skipSave)

await context.sync();

});
}

/** Default helper for invoking an action and handling errors. */
async function tryCatch(callback) {
try {
await callback();
} catch (error) {
// Note: In a production add-in, you'd want to notify the user through your add-in's UI.
console.error(error);
}
}

[ishanig11]

Thank you @shanshanzheng-dev . It worked. But is there anyway to avoid that popup?

[shanshanzheng-dev]

do you meaning this below picture? I think this is by design and we can't avoid it.

[ishanig11]

Yes, this dialog.

[shanshanzheng-dev]

Hi @ishanig11, I'm afraid that we can't avoid this dialog, this is by design. Thanks.