0

I have an excel addin which opens a dialog. How do I see the logs from the .html page or JS code that actually calls .displayDialogAsync to show the dialog?

For instance, I have a MyFunctions.html file, with following code (example)

<script>
  console.log("Running the Script"); // <------ HOW TO LOG THIS

  window.Offce.onReady(function(officeEvent){

    console.log("OfficeJS is ready"); // <------ AND HOW TO LOG THIS?

    window.displayDialog = function(event) {
     console.log("The button to show dialog was clicked");
     Office.context.ui.displayDialogAsync(....{...});
  }
}
</script>

How do I log and view the above 2 console statements? The first one - happens before Office JS is loaded - how/where to log and view it? I say so cos sometimes OfficeJS doesn't load properly or something is wrong, I want to see /log the issue.

And the second log statement - where do I see that too?

I could 'log to the excel sheet itself' however that doesn't help, cos what if there's an issue loading the Addin itself preventing the above from running

Hopefully all this makes sense.

I really want control to step by step debug the above code. I jsut cannot because above is not even visible when running Excel. The above html is only visible in a browser, which isn't help cos the addin doesn't run inside a browser, it runs in Excel.

Improve this question
3
  • To see the 2nd log, see if this article is helpful: Debug the initialize and onReady functions. For the 1st log, I've never heard a case of the JavaScript runtime loading, but Office.js failing to load. Do you have reason to think this happens? Commented Apr 4 at 19:12
  • Thanks @RickKirkham - read article above. what if your add in is not web-based at all? How would you start debugging then? Commented Apr 6 at 14:16
  • All add-ins that use Office.js are web-based. In fact, the full name of them is "Office Web Add-ins". Commented Apr 7 at 17:22
Related questions
1
Can I invoke Excel.run() in a page hosted inside an Excel dialog (using office-js addin technology)
1
Office addin does not persist with workbook across browsers
4
Office-js addin with Excel and Edge Webview - how to delete cache?
Load 3 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.