Troubleshoot an Office add-in using VS Code

Looking for guidance on Office add-ins and VS code...

I recently went through the steps outlined in this tutorial by Microsoft to create an Excel custom functions add-in. To debug it using VS code, I had to select TypeScript as the script type while creating an Excel Custom Functions Add-in project option in the Yeoman generator (as per Microsoft's instructions).

The add-in is functioning properly, but I encountered issues with the related debugging tutorial provided by Microsoft. Any breakpoints added are showing up as unbound, and I'm getting a "read source map" error, which might be connected (refer to screenshot).

Any suggestions on how I can resolve this?

Thank you for your assistance,

Adrian

Edit: below is the content of launch.json, which I haven't modified from what Yeoman generated.

{
  // Use IntelliSense to learn about possible attributes.
  // Hover to view descriptions of existing attributes.
  // For more information, visit: https://go.microsoft.com/fwlink/?linkid=830387
  "version": "0.2.0",
  "configurations": [
    {
      "name": "Excel Desktop (Custom Functions)",
      "type": "node",
      "request": "attach",
      "port": 9229,
      &q...

https://i.sstatic.net/aBXmE.png

exceltypescriptoffice-jsoffice-addinsexcel-web-addins

Answer №1

If you're looking to debug custom functions in Office Excel on the desktop without using a shared runtime, VS Code is your go-to option. Just remember not to incorporate the shared runtime in your add-in.

For debugging with Microsoft Edge, it's essential to have the Microsoft Edge DevTools extension for Visual Studio Code installed.

Similar questions

If you have not found the answer to your question or you are interested in this topic, then look at other similar questions below or use the search

Create a typescript class object

My journey with Typescript is just beginning as I delve into using it alongside Ionic. Coming from a background in Java, I'm finding the syntax and approach quite different and challenging. One area that's giving me trouble is creating new object ...

javascripttypescript

Are there any @types available for browser extension objects that are interoperable?

I am in the process of developing a browser extension that would work seamlessly on Edge, Chrome, and Firefox by utilizing Typescript. After coming across an article discussing interoperable browser extensions, I stumbled upon a code snippet: window.brow ...

typescripttypescross-browserbrowser-extension

I am unfamiliar with this scenario but I can utilize Axios, async/await, and TypeScript to navigate it

Having trouble creating a workflows list from an axios response Error: Argument of type 'Promise<unknown>' is not assignable to parameter of type 'SetStateAction<WorkflowForReactFlowProps[] | null>'. Here's the Axios c ...

javascriptreactjstypescriptaxios

Creating php-powered reports using Excel

How can I create an Excel sheet download feature using PHP? The numbers generated in my Excel report are not displaying correctly within the cells. How can I fix this issue? I need help ensuring that the numbers display properly in the cells of my Excel ...

phpsqlexcel

The TS2769 error occurs when trying to change the react calendar due to no matching overload in the

The calendar functionality in my project was implemented using the response calendar library. Suddenly, I encountered an onChange prop error in the default code. This was working fine before. What steps should I take to resolve this issue? Here is my cod ...

javascriptreactjstypescriptreact-calendar

Tips for showing JSON information in Nativescript

How can I display all values in a page using the provided JSON data? res { "StatusCode": 0, "StatusMessage": "OK", "StatusDescription": [ { "sensors": [ { "serial": "sensor1", "id": "1" }, ...

jsonangulartypescriptnativescript

Tips for preventing <v-layouts> from impacting one another

I'm currently working on a dynamic link box for a homepage website, which can be viewed at . Inside this link box, I have included a button that allows the creation of buttons that function as links. Interestingly, the layouts of both the options but ...

htmltypescriptvuetify.js

Absence of property persists despite the use of null coalescing and optional chaining

Having some trouble with a piece of code that utilizes optional chaining and null coalescing. Despite this, I am confused as to why it is still flagging an error about the property not existing. See image below for more details: The error message display ...

javascripttypescriptmaterial-ui

Compilation errors plague TSC on varying systems

After successfully creating a node app in TypeScript and running it locally without any issues, I encountered compilation errors when deploying the app on Heroku: app/api/controllers/ingredient.controller.ts(3,24): error TS2307: Cannot find module & ...

node.jstypescriptherokunpmtsc

Alert me in TypeScript whenever a method reference is detected

When passing a function reference as a parameter to another function and then calling it elsewhere, the context of "this" gets lost. To avoid this issue, I have to convert the method into an arrow function. Here's an example to illustrate: class Mees ...

typescripttypescript2.0

Prisma allows for establishing one-to-many relationships with itself, enabling complex data connections

I am in the process of developing a simple app similar to Tinder using Prisma. In this app, users can swipe left or right to like or dislike other users. I want to be able to retrieve matches (users who also like me) and candidates (all users except myself ...

mysqltypescriptprismaprisma2

How to effectively handle null values using try..catch statement in typescript

As a beginner, I am learning how to write a try/catch statement in TypeScript. My issue is that there is a function within the "try" block that returns null. How can I implement code in the "catch" block specifically for when the function in "try" returns ...

typescriptnulltry-catch

Issue with Nuxt: Property accessed during rendering without being defined on the instance

As I attempt to create cards for my blog posts, I encountered an issue with a Post component in my code. The cards are displaying like shown in the picture, but without any text. How do I insert text into these cards? Currently, all the text is within attr ...

javascripttypescriptvue.jsnuxt.js

Using Jasmine to Jest: Mocking Nested function calls

I am currently working on testing my TypeScript functions with Jasmine: //AB.ts export async function A() { } export async function B() { A(); } My goal is to unit test function B by mocking out function A to see if it is called. Here is the code I h ...

typescriptunit-testingjasminespyon

The module named "mongoose" does not have any member called 'PaginateResult' exported

I'm facing an issue while trying to add the necessary types for "mongoose-paginate" in my Angular 4 project setup with "angular-cli". The problem arises when Webpack throws an error. import {PaginateResult} from "mongoose"; ... getAll(page: number) ...

angulartypescriptwebpackangular-cli

Having difficulty maintaining trailing zeroes in decimals after converting to float in Angular

I need assistance with converting a string to float in Angular. Whenever I use parseFloat, it seems to remove the zeros from the decimal values. How can I ensure that these zeros are retained with the numerical values? The example below should provide more ...

javascriptangulartypescript

Guide on creating dynamic route paths for includes within a Pug template

Need help creating a dynamic include For example: h1 include path/#{object} or include path/+{object}+{a:true,b:11} Something similar to the above. If anyone knows how to achieve this using Mixins in pug, please provide an example for include. ...

node.jstypescriptexpresstemplatespug

Translate Firestore value updates into a TypeScript object

Here are the interfaces I'm working with: interface Item { data: string } interface Test { item: Item url: string } In Firestore, my data is stored in the following format: Collection Tests id: { item: { data: " ...

typescriptgoogle-cloud-firestoreangularfire2

Is there a way to specifically retrieve email addresses and transfer them onto an excel spreadsheet from an eml file with the help

After attempting to use this PHP script to extract email addresses from an eml file, I encountered a display issue when viewing it on the browser: Array ( [0] => <a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="ddb7b8aeaea4e5 ...

phpexceleml

The outcome of a promise is an undefined value

I am facing an issue where I need to access the result of my API call outside the promise, but the value I receive is always undefined. Within the OrderService : public async getOrderPrice(device: string) : Promise<any> { this.urlOrderPrice = th ...

angulartypescriptapipromisesubscribe