Excel Add-in Development

Come learn about how easy it is to develop an Excel Add-in and make use of some of the cool new APIs available. In today's stream, we will connect Excel to a live service and create custom functions to make this data accessible in Excel.
Chapters:
00:00 VS Code Livestream begins
00:27 Welcome
02:46 What we're talking about today
04:45 Excel Add-ins, Data Types APIs and Code
08:09 Add-in basics
10:02 Data Types
14:07 Data Types Feature Integration
15:38 Data Types APIs
16:02 Composable Building Blocks
17:47 Increasing Developer Velocity
19:04 New Values API
20:48 Demo - Meme Generator - an Excel Add-in
aka.ms/OfficeAddin/YeomanGene...
42:04 Excel JavaScript preview APIs
aka.ms/ExcelJavaScript/APIs
55:38 Generating memes in Excel
Recommended resources:
aka.ms/dataTypesValuesAsJson
aka.ms/ExcelAddins/Docs
aka.ms/Excel/DevelopOfficeAddins
aka.ms/ExcelJavaScript/APIs
aka.ms/OfficeAddin/YeomanGene...
Connect:
VS Code / code
Reynald / reynaldadolphe
Jakob / jakobpn
Chris / chrisgross123
Follow and Subscribe:
/ code
/ vscode

[@virendrakumar-zp8lv]

Thanks for this Video,This video is very eye opening. I implemented this. I have one question about Microsfoft loginn. I was trying to login with microsoft and login successfully, but after login my Task pane is not updating. It would be great if I will get the solution. thanks:)

[@indianappguy]

i cannot install the yomen generator

[@kamalam29]

Hi Reynald, Chris, and Jakob, could anyone please tell me how to start working on commercial web add-in projects? I'm sure the learning curve is currently very steep but the foundation is strong. I want to know, which platform does offer commercial projects? thanks.

[@sampadakajarekar2783]

I am not able to debug custom functions. I can debug taskpane code. Any help in setting up custom function runtime launch configuration ?

[@kunalmahtani4652]

I'm getting CORS error when calling the "fetch" function. This design is very limited, as most API services will throw a CORS error when trying to make any request.

[@laggytim]

Holy crap that start up very complicated compared to vba, i mean gatekeepingly complicated.

[@RoboLaboratory]

Hello!

[@jdchannelviewer]

Hi.