►
From YouTube: Office Add-ins community call-October 2020
Description
This month's call, hosted by David Chesnut covered topics including Visual Studio Code sideload for WAC, Outlook and Excel Ignite Recap and a demo of PnP Open in Excel.
Speakers: David Chesnut, Courtney Owen, Juan Balmori, Keyur Patel
Stay connected
Twitter https://twitter.com/microsoft365dev
YouTube https://aka.ms/M365DevYouTube
Blogs https://aka.ms/M365DevBlog
A
B
A
Side
load
for
office
online
and
then
juan's
going
to
talk
about
some
outlook,
add-ins
updates
that
have
come
out
and
then
kayer
is
going
to
talk
about
some
excel
updates
at
outstatic
night
and
then
I'll
be
doing
a
demo
of
a
new
patterns
and
practices
sample.
We
have,
it
shows
how
to
open
up
in
excel,
and
then
we
have
some
q
a
at
the
end
and
if
you
have
questions
just
type
them
into
the
chat
and
we
will
be
answering
those
as
we
go
along.
A
C
Okay,
folks,
today,
I'm
going
to
talk
about
registering
add-ins
to
office
online,
using
query
parameters
and
if
any
of
you
have
ever
worked
with
add-ins
and
office
online,
you
know
that
the
registration
process
is
currently
manual
and
it
can
be
a
little
tedious
to
have
to
do
things
manually.
It's
also
not
great
from
a
developer
experience
and
that
every
time
you
make
a
change
to
your
manifest,
you
have
to
manually
upload
it
again
and
it's
just
not
a
quick
process.
C
So
if
any
of
you
have
ever
used
our
yoga
office
tool
to
create
an
add-in,
you
probably
know
that
you
can
automatically
register
your
ad
in
desktop
and
I'll.
Give
you
an
example
of
that.
So
this
is
a
yo
office
project
and
it's
just
a
task
pane
project.
So
if
I
go
npm
start
here,
you'll
see
that
we
boot
up
word
and
we
automatically
register
the
add-in
starting
the
dev
server
right
there
booting
word
and
see
the
add-in
was
automatically
registered
and
that's
a
really
nice
thing
from
a
developer
standpoint.
C
C
Not
only
do
developers
want
it,
but
we
also
would
like
it
from
a
test
standpoint,
because
every
time
we
make
changes
to
our
project
templates,
we
have
to
manually
test
them,
and
if
we
had
an
automated
approach
to
doing
it,
it
would
allow
us
to
which
each
time
we
make
a
change
to
have
a
test
that
that
goes
through
and
executes
and
does
it.
So
I
just
want
to
show
you
the
current
process
of
registering
an
add-in
in
word,
for
example,
so
I
go
insert
add-ins
upload,
my
add-in
browse
select
my
manifest
upload.
C
Then
I
have
my
add-in,
so
this
is
not
really
great
from
a
developer
standpoint
that
you
have
to
do
all
these
manual
steps
and
each
time
I
change
the
manifest.
I
have
to
go
through
that
step
again,
so
I'm
going
to
go
ahead
and
clear.
My
cache
here
for
the
sake
of
my
demo,
so
this
add-in
is
not
here
anymore,
go
ahead
and
close
this
okay.
C
C
And
what
that'll
do
is
that
will
start
the
dev
server
it'll,
look
and
see,
there's
a
document
parameter
here
and
it
will
construct
the
query.
Params
and
the
query.
Params
will
look
like
this,
so
what
we
have
here
is
we
have
the
dev
server
port
3000,
I'm
running
in
the
manifest
file
name,
which
is
just
my
manifest.xml
here
and
then
the
manifest
guide
and
the
manifest
guide
is
just
a
unique
id
from
here,
and
so
I'm
going
to
show
you
here
how
running
the
start.
C
C
C
Our
internal
security
folks
wanted
some
mechanism
in
place,
so
people
just
don't
send
you
a
url
and
maliciously
cause
you
to
add
an
add-in
to
your
documents
that
might
cause
some
sort
of
nefarious
things
to
happen.
So
we
opt-in
after
we've,
carefully
read
all
of
the
documentation,
of
course,
and
then
what
that
does
is
it
sets
a
value
in
your
local
storage
that
says,
you've
opted
in
then
the
next
time
I
run
this.
C
C
C
C
So
I'm
going
to
demo
that
next,
so
I'm
going
to
go
and
click
on
my
debug
here
and
I'm
going
to
do
office
online
and
you're
going
to
see
what
you're
going
to
see
here
is
the
browser
open
and
it's
going
to
open
in
chrome
and
the
reason
I'm
using
chrome
and
not
edge,
is
because
we're
having
problems
with
the
edge
debug
extension
attaching
right
now.
I
have
conversations
going
on
with
the
edge
folks
right
now
about
why
that
is
so.
C
C
C
Now,
okay,
so
I
clicked
on
that
demo
time
and
you
see
how
we
hit
our
break
point
right
there,
so
I'm
just
going
to
go
ahead
and
continue
and
then
I'm
going
to
change
this
paragraph
color
to
red,
so
we
can
do
stuff
during
debug
time
and
it'll
show
up
and
then
continue
and
go
back
to
our
document
and
you
see
red.
Similarly,
I
can
go
in
here
and
change
this
while
we're
attached,
and
this
should
build
again
there.
C
This
is
something
that
we've
wanted
to
have
for
a
while
and
it
you
know
internally,
it's
a
really
nice
thing
for
us
testing,
but
we
think
it
should
be
a
good
thing
for
developers
as
well.
Now
what
I
demoed
this
morning
was
word.
You
could
also
do
this
in
one
note
now
and
ultimately,
it
will
be
supported
in
word,
onenote
powerpoint,
which
I
just
checked
in
last
night
and
excel,
which
is
in
code
review
right
now
you
may
be
asking
yourself
will
outlook.
C
A
C
So
this
the
ability
to
use
query
params
is
available
in
fast
food
right
now
for
word
and
onenote,
and
so,
if
you
were
to
want
to
try
this
out
yourself
did
I
just
I
think
I
killed
my
desktop
session.
I
can
put
the
query
params
in
the
chat
session
and
they
can
append
those
to
the
end
of
their
document
document
url
if
they're
in
fast
food.
C
If
they're
you
know
in
production,
it's
not
turned
on
yet
in
there.
The
tooling
that
I
showed
you
is
not
going
to
be
available
until
we've
turned
it
on
in
prod
in
production,
so
hopefully
in
the
next
month,
we'll
have
all
this
available.
But
if,
if
people
do
want
to
try
it
out
right
now,
they're
in
fast
food,
they
can
run
the
query
params
that
I'll
put
in
the
chat
window.
C
C
D
D
So
basically
I
have
two
things
that
I
want
to
talk
to
you
today,
which
is
basically
just
a
quick
recap
of
what
our
participation
during
the
ignite
conference.
That
was
a
few
weeks
ago,
and
also
I
want
to
talk
about
an
important
update
for
outlook
add-ins
and
how
they
work
within
optional,
connected
experiences.
D
D
We
had
a
virtual
hub
where
many
teams
were
publishing
kind
of
videos
of
you
know
their
feature
areas
and
in
the
case
of
outlook
there
are
two
videos
that
are
very
relevant
for
outlook.
Addings,
that
I
I
recommend
you
to
to
take
a
look.
This
is
just,
I
think
the
first
one
is
around
the
35
minutes
and
the
second
one
is
it's
a
bit
shorter
than
that,
but
it's
very
comprehensive.
It
has
all
the
details.
You
need
to
know
about
the
latest.
D
I'm
gonna
show
you
a
quick
recap
of
what
we
talked
about
that
please
again
go
here
to
see
the
video
it's
it's,
it's
actually
really
cool
and
then
the
second
video
it's
it
was
more
targeting
end
users,
and
I
t
pros-
and
it's
about
you
know
and
increasing
your
productivity
with
office
add-ins,
and
this
video
is
actually
I
like
it
a
lot
because
it
shows
how
end-users
can
actually
take
advantage
of
add-ins.
You
know
across
different
products
now
there
this
this
is.
D
We
showed
a
problem
where
many
people
are
participating
to
solve
it
within
an
organization
and
how,
by
using
different
add-ins
in
excel
work
and
an
outlook
they
are,
they
can
get
way
more
productive.
You
know,
and
we
showcased
a
few
outlook
cuttings
here.
I
want
to
highlight
two
of
them
gyra,
it's
it's.
D
So
please
go
go
there
and
watch
those
videos,
I'm
just
going
to
do
a
quick
recap
of
the
second
one,
which
is
what
started
in
developer
developers
and-
and
here
are
the
latest
news
in
outlook
add-ins.
Now.
First
of
all,
I
have
sure
we
have
shared
this
in
this
call,
but
we
double
down
on
announcing
that
single
sign-on
is
released.
It's
work,
it
works
for
outlook
audience
as
well
scribdlab
you
guys.
I
I
think
I
showed
you
them
about
this
a
few
weeks
ago.
D
D
Android
is
already
g8
a
few
months
ago
and
then.
Finally,
the
golden
kind
of
announcement
is
that
we
announced
that
1.9
the
1.9
requirements
set
for
the
outlook
javascript
api.
You
know
it
was
kind
of
almost
you
know.
Ga,
no,
the
good
news
here
and
what
I
want
to
share
with
everybody
here,
is
that
the
plan
that
we
have
is
that
we
are
going
to
ga
1.9
by
end
of
next
week.
D
So
right
now,
we
are
in
the
last
in
the
last
phases
of
making
sure
that
our
documents
are
ready
ready,
for
you
know,
production
for
the.
You
know
to
show
no
longer
on
preview,
but
it's
in
in
production,
so
you
should
be
able
to
get
to
start.
You
know,
obviously
start
building
your
add-ins
and
submit
add-ins
to
the
store
that
are
using
the
1.9
requirement
set.
D
You
know
you
can
insert
either
just
plain
text
or
html,
and
the
idea
here
is
that
we
don't
want
users
to
kind
of
accidentally
remove
content
that
is
required
within
the
organization
now,
for
example,
if
you're
sending
an
email
to
an
external,
an
external
address
or
if
you're
you
know
talking
about
kind
of
sensitive
content,
we
don't
want
users
to
be
kind
of
removing
that.
So
that's
why
this
this
scenario
becomes
really
relevant
right
now,
the
store
is
ready
to
start
getting.
D
Add-Ins
that
are
using
append
on
send
remember
that
append
on
send
requires
developers
to
have
an
entry
on
our
manifest.
So
so,
basically
you
need
to
submit
an
update.
You
write
into
the
story
if
you're
going
to
be
using
append
on
send
and
in
the
description
of
your
add-in,
it's
going
to
be
validated
that
you
guys
are
disclosing
the
content
that
is
attended,
so
that's
going
to
be
tested
and
validated.
So
there
you
go
so
expect
you
know
end
of
next
week,
a
blog
post
from
our
team.
D
Just
during
the
formal,
you
know
ga
of
the
feature
right
now.
The
second
part
of
the
of
the
video
you
will
see
that
it's
about
event-based
add-ins.
So
this
is
for
those
of
you
who
are
not
yet
aware
of
this,
we're
basically
releasing
a
new
way
of
creating
outlook,
add-ins
that
it's
based
on
events.
So
today,
basically,
what
happens
with
add-ins
in
outlook
is
that
if
you
want
to
use
them,
you
basically
need
to
go
as
I'm
showing
in
this
video.
You
need
to
go.
D
Click
either
show
the
tasking
or,
or
you
know,
call
call
a
ui
less
command.
It
requires
the
user
to
basically
click
on
a
button
in
the
ribbon
or
in
the
task
pane
to
execute
code.
So
you
cannot
be
running
kind
of
in
the
background
right
with
event-based
add-ins,
this
video.
What
is
showing
it's
a
kind
of
a
very
simplistic
example
that
I
am.
I
want
to
add
somebody
to
the
two
line
on
this
email.
D
If
you
do
it
with
regular
add-ins,
you
have
to
go
and
click
show
a
task
pane
or
a
button
or
add
recipients,
no
with
event
driven
audience.
This
is
going
to
be
way
different.
It's
basically
as
a
developer.
You
can
subscribe
in
this
case
to
certain
events
in
this
case
for
the
uncomposed
event
and,
basically,
you
know
execute
code
as
part
of
it
and
also.
D
So,
basically,
during
this
presentation,
we
we
showed
a
partner
of
us
cove2,
which
is
also
signature
provider
was,
was
sharing
a
lot
of
detail
of
what
how
they
are
implementing
their
adding.
It's
really
awesome,
so
I
recommend
you
to
see
it
right.
So
those
basically
those
are
through
the
main
content
that
we
presented
on
this
video
here
are
some
useful
links.
D
The
idea
of
optional
connected
experiences
is,
is
basically
within
organizations
or
even
end
users.
They
can.
Actually,
let
me
show
you
actually
let
me
let
me
give
you
a
quick
sample
of
what
is
that,
so
this
is
a
setting
that
can
be.
You
can
actually,
as
an
end
user
configure
it.
So
if
you
go
to
trust
center,
that's
all
again,
so
I
went
to
file
options
and
then
you
go
to
trust
center
trust
center
settings
and
you
go
to
privacy
options.
D
D
There
are
engines
that
are
connecting
to
you
know
basically
the
internet
to
provide
you
with
services
right
and
as
an
end
user
or
as
an
it
admin.
This
can
be
a
set.
This
can
be
set
by
it
admins.
You
can
basically
turn
off
all
the
connections.
We
call
that
connected
experiences.
Basically,
you
use
the
kind
of
standalone
office,
and
in
that
context
you
can
turn
on
some
optional
connected
experiences
like,
for
example,
smart,
lookups,
the
outlook,
weather
and
many
other
features,
including
alliance.
D
So
so
many
customers,
big
and
small,
we're
asking
us
to
you,
know
what
we
should.
We
should
at
least
allow
a
curated
list
of
addings
to
be
deployed
within
my
organization
and
that's
exactly
what
we
did
so
right
now.
What
I
want
to
show
you
here
is
a
quick
demo
here,
guys
I
right
now
I
I
have
I
have
connect.
I
am
connected
experiences
on,
which
means
I
can
basically
go
to
the
store
and
acquire
add-ins.
D
You
know-
and
I
want
to
show
you
here-
I
have
multiple
add-ins
installed
on
this
on
this
in
this
example.
So
if
you
go
to
my
add-ins,
you
will
see
that
there
are
some
store
add-ins
that
I
myself
installed.
I
went
directly
to
the
store
and
installed
them
which
are
salesforce
docusign
and
google.
Myths
right
and
there
are
other
set
of
sets
of
add-ins
that
were
installed
by
my
organization.
D
Basically,
an
I.t,
an
admin
within
my
organization
released
these
add-ins
either
from
the
store
or
or
you
know,
home,
built
to
the
organization
right,
so
I
can
see
both
of
them
in
this
case
right,
you
will
see
that
when
I
I'm
going
to
turn
off
connected
experiences-
and
you
will
see
that
the
expected
outcome
of
that
is
that
I
will
not
be
able
to
see
the
store,
but
I'm
gonna
be
able
to
see
the
admins
that
were
deployed
by
itino.
So
let
me
show
you
in
this.
D
In
this
case,
this
is
the
the
administration
experience.
Now,
if
you
go
to
add-ins
within
admin
center,
you
will
see
that
as
any
pla.
In
this
example,
I
deployed
a
bunch
of
items
within
my
organization
because
I
love
aliens
and,
let's
see
what
happens
so
if
I
go
to
again
file
options
to
do
the
whole
thing
again,
transfer
and
settings
privacy
options.
D
D
Okay,
so
I'm
gonna
restart
outlook,
and
now,
once
I
restart
I'm
gonna
be
basically
in
in
optional,
connected
experiences
of
situation
right.
So
previously
I
didn't
have.
As
you
can
see,
there
is
a
bunch
of
movement
on
the
ribbon.
You
see
that
the
many
things
happen
here.
First
of
all,
I
don't
have
access.
D
I
still
don't
have
access
to
the
store,
but
there
are
a
bunch
of
add-ins
that
are
actually
installed
that
were
the
ones
that
were
deployed
by
my
my
organization
and
if
I
go
to,
I
don't
know
a
meeting
and
I
create
a
new
appointment
here.
You
will
see
that
you
know
the
admin
in
this
case
also
activated
blue
jeans,
script
lab
and
other
another
add-ins.
You
know
so
right
now.
I
am
just
using
the
add-ins
that
were
deployed
by
my
administrator
right.
D
So
that's
basically
the
the
feature,
and
so
it's
very
simple
but
powerful
and
and
then
it's
solving
a
very,
very
targeted
problem
that
is
shared
by
our
our
community
and
finally,
what
I
want
to
tell
you
is-
and
you
know
right
now,
this
update
is
released.
It's
it's
starting
version.
2008
ex
specifically
build
this
build
right
here.
D
So
basically,
if
you
update
your
mo,
if
you're
in
the
monthly
channel-
and
you
update
your
office
today,
you're
able
to
to
get
this
experience
on
the
monthly
channel
and
now
many
customers
are
in
the
semi-annual
channel,
which
is
the
one
that
that
updates
two
times
a
year
right
now,
it's
in
preview
on
the
semi-annual
channel
the
plan
is
that
we're
gonna
release
it
as
part
of
the
update
happening
early
january
turning
21.,
so
very
close
from
today,
we'll
be
on
october.
It's
the
last
quarter
of
the
year,
so
people
in
organizations
can
actually
try.
D
A
B
B
B
We
talked
about
single
sign-on,
which
matt
was
on
a
couple
of
months
ago,
highlighting
the
general
availability
for
not
just
a
in
excel
across
word,
excel
powerpoint
outlook
and
then
likewise
across
the
full
platform.
We
also
put
a
reminder
around
trying
the
edge
webview
to
control,
as
our
colleague
studio
has
been
on.
The
call
before
one
of
the
things
he's
mentioned
is
like
hey.
This
is
something
that
is
top
of
mind
for
us,
because
we
think
this
will
one
make
it
that
much
easier
for
you
to
support
and
create
add-ins.
B
But
two,
ultimately,
we
were
like
hey.
We
think
this
is
going
to
be
the
browser
of
the
future,
at
least
on
windows,
and
so
having
a
great
experience
here
makes
sense,
so
anything
that
you
can
do
to
help
us
test
this
and
find
issues
before
we
make
this
feature
generally
available
later
this
year
would
be
awesome,
and
so
that
that
was
just
starting
with
the
platform
capabilities,
and
then
we
talked
about
another
requirements
that
that
we
launched
and
it's
really
cool
like
in
terms
of
excel
excel.
B
When
you
think
about
it,
is
it
it's
super
deep
and
there's
a
thousands
upon
thousands
of
apis
and
today,
where
we
have
over
2000
now,
and
so
this
started
with
a
big
push.
As
the
team
said,
okay,
we
actually
need
to
start
to
focus
on
getting
to
api
parity,
and
one
of
the
things
we
originally
did
that
one
previously
would
talk
about
was
was
hey,
focusing
on
what
are
our
most
commonly
used
apis
and,
more
recently,
we've
taken
a
different
approach
in
terms
of
hey.
B
How
can
we
unblock
the
most
solutions
end-to-end
most
quickly
and
so
looking
at
like
hey?
What
are
the
gaps
in
terms
of
helping
the
community
ship
their
add-ins
specifically,
and
now?
I
think
it's
great
to
see,
because
I
think
this
is
working
because
we're
seeing
more
add-ins
being
shipped
out
to
production
at
the
same
time,
this
long
tail
is
gonna,
continue
to
exist,
and
so
we'll
continue
to
pick
a
few
things
and
keep
releasing
these
in
apis
and
one
of
the
things
that
we
didn't
talk
about
at
ignite,
but
in
terms
of
apis.
B
Just
to
give
you
a
preview
of
what
we
are
working
on,
raymond
and
team
are
going
to
be
looking
at
the
ad
from
base64
api.
We
do
have
that
we
do
have
a
goal
to
get
that
out
as
quickly
as
possible.
That's
out
of
beta,
so
we're
internally
talking
about
hey.
What
are
our
options
to
make
that
available,
so
those
were
some
of
our
apis
and
then
the
next
segment
of
things
that
we
talked
about
were
just
around
our
user
experiences.
B
So
earlier
this
summer
we
announced
the
dialogue
api,
where
you
can
do
two-way
messaging,
and
I
believe
this
one
also
works
across
word
excel
and
powerpoint
and
then
with
excel.
Specifically,
we
have
the
enable
disable
ribbon
apis,
which
you
can
run
they're
a
part
of
the
shared
runtime.
These
are
all
also
now
generally
available.
B
One
of
the
features
that
we've
heard
from
is
hey.
People
want
to
not
only
enable
disable
buttons
on
add-in
commands;
they
want
to
hide
and
show
them
and
in
terms
of
our
user
experiences,
we
want
these
user
experiences
that
you
create
from
your
add-ins
to
be
as
consistent
with
the
user
experiences
that
office
has
and
one
of
the
things
that
office
has
moved
away
from.
B
Is
this
idea
of
hey
any
of
our
built-in,
like
tabs,
hiding
and
showing
buttons,
and
instead
the
paradigm
that
we
have
is
now
a
contextual
ribbon
tab,
and
so
what
contextual
ribbon
tabs
are
is
essentially,
let's
say
you
have
a
chart
instead
of
powerpoint
or
excel
or
a
picture,
and
you
click
on
that
picture.
A
new
tab,
pops
up
with
additional
options
and
so
that
these
contextual
ribbon
tab
apis,
really
allow
you
to
declaratively,
create
new
ribbon
tabs
based
off
of
either
what
the
user's
context
is
or
what
theirs
was
selecting.
B
B
Our
goal
isn't
just
to
keep
that
for
excel.
We
will
start
with
excel
here,
but
we'll
make
it
available
to
all
of
our
hosts,
so
that
was
it
one
one
other
additional
callout
to
make.
Is
we
also
had
a
video
on
office
scripts,
so
the
office
scripts
are
available
on
in
excel
for
web
two
announcements
there
that
you
may
not
have
seen
one?
Is
we
recapped
our
simplified
apis?
B
So
for
end
users
we
know
hey
the
async
pattern
of,
and
context.sync
and
batching
is,
would
be
too
difficult
to
understand,
and
so
the
simplified
apis
really
abstract
away
the
asynchronous
city
and
make
it
really
look
like
just
simple
commands,
as
you
had
in
like
vba,
the
the
other
big
feature
on
excel
for
web,
not
necessarily
a
feature.
It's
a
switch
that
we
made
as
we
work
our
way
to
become
generally
available
for
office
scripts.
B
Is
it's
now
enabled
by
default,
so
this
is
rolling
out
so
before
it
admins
had
to
go
you'd,
add
you'd
have
to
ask
your
I.t
admin
to
turn
on
the
feature.
Now
the
feature
is
on
by
default.
Of
course
it
admins
can
still
disable
that,
so
that
was
it
from
the
excel
side.
We
have
a
bunch
of
great
new
stuff
coming
down
the
pipeline,
and
this
is
the
place
to
be
to
learn
about
that.
Thank
you.
A
Cool,
thank
you
all
right,
so
I'm
going
to
talk
about
a
new
patterns
and
practices
sample
that
we
have
called
open
in
excel.
Just
a
real,
quick
background.
What
the
scenario
is
about
is,
if
you
have
a
sas
web
application,
where
folks,
you
know,
are
working
with
data
on
your
website,
there's
often
a
point
where
they'll
want
to
take
that
data
into
excel
to
continue
to
work
out
in
some
way.
You
know
maybe
doing
additional
analysis
or
creating
charts,
and
you
know
the
way
this
would
work
in
the
past
is
you'd.
A
Let
them
export
a
csv
file.
Traditionally,
this
is
how
it
would
work.
You
know
you
create
a
csv
file.
The
user
then
has
to
go
import
that
into
excel,
and
then,
if
they
want
to
remain
connected
to
your
services
like
say
you
have
an
office
add-in.
They
have
to
go,
find
that
office
add-in
in
the
store
or
through
central
deployment
and
get
it
set
up.
A
So
there's
a
number
of
steps
for
them
to
go
through
and
the
idea
of
this
scenario
is
like
hey:
let's
simplify
that,
so
it's
as
close
to
one
click
as
possible,
where
someone
can
just
say:
hey,
take
my
data
open
in
excel
your
office.
Add-In
is
already
there
and,
as
we'll
see,
this
goes
to
the
steps
of
using
office,
open,
xml,
to
embed
your
add-in
and
create
the
file
and
then
using
microsoft
graph.
You
can
upload
the
file
to
onedrive.
This
stereo
was
actually
demoed.
A
A
year
ago,
in
september
of
last
year,
by
jake
armstrong
at
venice
corporation
they've
actually
implemented
this
office
add-in
very
successfully,
and
that
was
a
great
demo
show.
So
basically,
this
pattern
is
taking
that
same
approach
and
showing
you
how
to
do
it.
So
let
me
get
over
to
some
demo
stuff,
let's
start
with
okay,
so
here's
the
article
for
open
in
excel
and
what
this
does
is
it
uses
a
an
existing
sample
on
github
called
the
office
ooxml
embed
add-in.
A
So
this
has
actually
been
out
there
for
a
couple
of
years
now.
I
think
I
guess
three
years
going
to
the
history
here
and
what
this
does
is
it
allows
you
to
take
an
existing
file
and
insert
the
script
lab
add-in
into
it,
and
so
basically,
what
we
did
is
we
took
this
approach
and
showed
you
how
you
could
extend
this
to.
You
know,
make
it
more
into
in
kind
of
scenario.
A
Let
me
go
ahead
and
run
it.
Oh
sorry,
I'm
like
there
we
go.
So
this
is
the
sample.
It's
an
asp.net
web
application.
I'm
gonna
go
ahead
and
run
it
and
you
can
see
what
the
web
page
looks
like
and
basically
it
just
has
steps.
One
two
and
three:
we're
gonna
go,
find
a
file
and
embed
script
lab
into
it
and
then
we're
going
to
download
it
back
and
then
we'll
see
what
that
looks
like
so.
The
first
step
here
is:
I
want
to
go
choose
which
file
I
want.
A
I
already
have
this
contoso
workbook
spreadsheet,
that
I'll
use
and
open
that
then
I'm
going
to
click
on
this
upload
button,
which
is
going
to
read
that
spreadsheet
into
memory.
So
now
it's
stored
in
memory
in
the
web
application.
The
next
step
is
I'm
going
to
embed
script
lab
into
that
file.
There's
an
option
here
to
specify
which
code
snippet
you
want
to
see
in
there
I'll
just
use
the
default
one.
A
A
You
know
there's
additional
parts
you
can
do
now
just
to
show
how
this
works.
Let's
see
I'm
going
to
close
this
and
I
think
the
easiest
way
to
show
what's
going
on
here
is
to
go
to
that
balance
folder,
where
it
created
the
new
spreadsheet
instance,
and
as
you
probably
know,
these
are
always
zip
files.
So
if
you
just
rename
a
spreadsheet
to
a
zip,
then
it
becomes
a
compressed
file
and
you
can
go
into
it
and
see
the
entire
open,
xml
structure
of
it.
A
A
Let
me
open
this
up
and
show
you
what
it
looks
like
and
you
can
see
a
lot
of
this
is
pretty
boilerplate
like
it
just
never
changes
when
it's
into
the
next.
The
key
parts
to
understand
are,
like
you
want
to
put
in
your
in
this
case,
like
the
store
id
of
of
where
your
that
identifies
it
in
the
your
alpha
set
and
in
the
store
and
your
store
type.
A
You
can
do
this
with
the
store
or
essentially
deployed
add-ins.
Then
you'll
want
to
pass
some
properties.
This
part's
important
here
you
want
to
have
this
office.auto
show
task
pane
with
document
set
to
true:
that's
what
causes
the
task
pane
open
and
then
this
is
a
custom
property
here,
just
for
a
script
lab
that
says:
hey
here's,
the
snippet
to
import
and
we
pass
it
that
this
is
that
default
snippet
id,
so
you
can
put
whatever
custom
properties
you
need
for
your
office
add-in
into
this.
Basically,
what's
a
property
bag?
A
A
This
is
where
openxml
comes
into
play
and
if
I
go
back
to
the
code,
I
have
opened
up
in
the
asp.net
project,
this
ooxml
helper.cs
file
and
here
there's
helper
functions
such
as
validating
the
office
file,
which
basically,
you
use
the
open
xml
to
open
the
file
and
if
it
opens
it's
valid,
if
it,
if
there's
an
exception,
it's
not
valid.
That's
pretty
simple!
How
that
works
now
to
actually
embed
the
office.
Add-In
that
happens
here.
A
So
I
just
like
to
explain
this
by
saying,
like
basically,
all
this
code
here
is
creating
that
file.
You
just
saw
that's
all
it's
doing
so
we
can
see,
here's
that
the
my
store
id
store
type
and
so
on
all
these
values.
So
if
you're
using
your
own
office
add-in,
this
is
where
you'd
want
to
make
your
change
so
use
your
particular
id.
A
Here's,
where
you
make
sure
your
auto
show
task
pane,
is
document
set
to
true.
If
you
have
custom
properties,
you
want
to
add
here's
where
you
do,
that
you
throw
them
into
this
property
bag.
Anything
you
need
and
that's
pretty
much
it,
and
then
this
part
for
the
task
pane.
This
is
always
the
same.
This
doesn't
change.
A
So,
let's
see
that's
pretty
much
how
that
works.
Let
me
go
back
over
to
the
article,
so
this
is
basically
a
part
one
of
the
sample
we're
going
to
do
a
part.
Two,
that's
more
end
to
end
because,
as
you
can
see
right,
basically
what
we're
doing
is
saying:
okay,
here's
this
sample,
you
can
start
with
and
then
you'll
want
to
do
some
additional
things
to
it.
A
Then
you'll
want
to
upload
to
onedrive.
If
your
users
are
using
onedrive,
it's
more
convenient
if
you
just
integrate
that
right
into
onedrive
for
them.
So
there's
some
steps
here
to
create
a
microsoft
graph
project
that
shows
you
the
code
for
uploading
to
onedrive
that
you
can
add
into
your
solution
also
because
this
this
sample
uses
an
existing
spreadsheet
you'll,
probably
want
to
create
a
brand
new
spreadsheet.
A
And
so
there
are
some
links
here
and
I
I'd
realize
as
far
like
this
link's
broken
so
I'll
go
back
and
fix
this,
but
there's
additional
articles
that
show
hey
here's,
how
you
create
a
spreadsheet
document
using
open
xml
and
then,
if
you
want
to
read
the
custom
properties,
if
you're
running,
how
does
my
office
add
in
read
those
properties
out
of
that
property
bag?
There's
an
article
on
that
which
I
will
fix
that
link
as
well.
A
A
So
one
option
is
you:
there
is
an
open,
xml
sdk
for
javascript
that
you
could
use
another
approach.
If
that
doesn't
work,
is
you
could
isolate
the
open
xml
code?
Part
that,
like
embeds
the
add-in
into
say,
like
an
azure
function,
some
kind
of
web
function
that
that
part
runs.net,
but
it's
separate
from
your
web
application.
So
you
can
continue
to
use
whatever
platform
you're
using
with
your
with
your
web
application.
A
A
I
think
there's
anything
else.
I
need
to
show
on
that.
Oh,
so
let
us
know
I'm
going
to
go,
create
I'm
going
to
start
an
issue
in
the
pnp
repo
and,
if
folks
want
to
give
us
feedback
on
that
issue
like
one
of
the
questions
we
have
is
like
you
know
which
of
these
approaches.
If
we
built
in
in
scenario
like
would
you
want
to
see
you
know
putting
out
oxml
in
an
azure
function
as
an
approach,
or
would
you
want
to
see
one
of
these
other
approaches
right?
A
So
I'm
going
to
jump
back
to
the
slides
and
next
up
is
our
community
spotlight.
So
I
want
to
send
a
big
thank
you
to
martin
van
stamm
martin's
been
helping
us
with
reviewing
prs
and
looking
at
issues
on
the
pnp
repo
last
month.
He's
made
some
contributions.
I
was
also
on
a
twitch
live
stream.
That
martin
runs
every
thursday.
I
attended
one
last
week,
which
was
just
kind
of
fun
going
through
looking
at
pr's
and
things.
A
So
you
know
if
you
want
to
contribute
to
the
repos
like
the
pnp
repo,
that's
out
there
for
the
community,
and
it's
intended-
you
know
be
by
the
community
for
the
community
and
we
recognize
all
contributions.
This
is
one
of
the
ways
of
doing
it.
We
also
recognize
contributions
in
a
monthly
blog
summary
that
we
send
out.
A
So
thank
you,
martin
for
that
and
moving
along,
we
got
some
q
and
a
we
had.
A
number
of
questions
come
in
from
our
office
forum.
So
I
wanted
to
take
a
look
at
those
real,
quick
here,
they're,
I'm
kind
of
lumping
some
of
these.
Together.
We
had
a
number
of
questions
that
were
all
around:
what
are
the
powerpoint
apis
plan
going
forward?
Officejs
apis
plans
like
which
apis
are
you
building,
hey,
I'm
blocked.
A
Trying
to
you
know,
I
need
this
specific
api
for
powerpoint,
so
I
can
build
my
add-in,
so
I
think
actually
chair
pretty
much
addressed
this
when
he
was
talking
about
the
excel
api
surface
earlier.
You
know,
like
our
our
approach,
you
know
if,
like
if
you're
looking
at
vsto,
which
has
a
huge
api
surface
area,
our
approach
is
to
prioritize
the
scenarios
that
unlock
you
know
the
most
folks
out
there.
A
So
the
most
helpful
thing
is
like
to
let
us
know
which
scenarios
you
need
enabled
and
then
we
can
take
a
look
at
those
for
planning
purposes
and
the
way
to
do
that
is
to
go
to
the
user
voice
site,
which
is,
let
me
see
that
over
here,
there's
also
the
link
at
the
end,
but
you
can
go
on
here
and
let
us
know
what
you
need
and
we
take
a
look
at
those
on
a
periodic
basis
to
do
our
planning.
There's
a
specific
question
about
powerpoint
the
document.doingdocument.save
again.
A
A
So
as
of
today,
our
focus
is
on
javascript,
we're
not
really
focused
on
blazer,
but
there
is
a
user
voice
request
for
blazer,
so
I
would
say,
if
you're
interested
in
that
definitely
go
up,
vote
that
or
comment
on
it
and
let
us
know
and
we'll
keep
an
eye
on
it
going
forward
and
one
other
question
that
came
in
was
how
do
I
close
my
documents
so
if
you're
in
excel,
you
can
actually
close
your
workbook
by
using
and
here's
the
code
sample,
context.workbook.close
and
that'll
work.
However,
this
is
not
available
in
word
or
powerpoint.
A
So,
if,
if
you
need
it
in
either
those
host
applications
again
go,
let
us
know
on
user
voice,
about
that
scenario
and
and
hopefully
gets
uploaded,
and
we
take
a
look
at
it.
So
hopefully,
we're
doing
well
on
the
other
questions
coming
in
over
chat,
so
I'm
going
to
keep
on
moving
here.
So
if
you
want
to
engage
with
us
in
the
future
like
if
you
want
to
present
during
an
upcoming
call,
that
would
be
fantastic.
A
We
love
having
folks
come
present
from
the
community
about
things
that
they're
doing
that
are
interesting
to
share
with
other
folks.
There's
a
link
here
to
the
office.
Add-Ins
engage
that
aka
ms
link.
We
can
provide
some
details
about
yourself
and
what
you
want
to
present
on
and
let
us
know
we'll
reach
out
to
you.
You
can
also
use
this
just
to
give
us
feedback
on
the
docs.
If
you
want
to
do
that
as
well.
A
If
you're
new
to
office
add-ins,
here's
some
ways
to
get
started.
If
you
go
to
the
aka
ms
link
for
office,
add-ins
docs,
there's
a
number
of
quick
starts
on
there,
where
you
can
just
you
know,
build
the
first
office
add-in
in
under
five
minutes,
great
way
to
get
started,
or
you
can
go.
Take
a
look
at
script
lab,
which
is
a
nice
way
to
you.
A
Don't
have
to
set
up
a
dev
environment
that
way
you
just
go
into
the
add-in
and
you
can
try
out
some
code
and,
if
you're
looking
to
do
some
automation
stuff,
like
automating,
excel
tasks,
go
check
out
office
scripts
at
the
aka
ms
office
scripts
docs
link
some
additional
developer
resources
for
folks
there
is
the
microsoft
365
developer
program,
which
allows
you
to
get
a
free
tenant
for
developing
and
testing
purposes.
So,
if
you're
serious
about
doing
office,
edits
development,
definitely
take
a
look
at
that.
It's
very
helpful.
A
There's
also
script
lab.
There's
a
link
for
that
to
try
that
out.
It's
very
helpful
for
just
trying
things
quickly
to
see
how
they
work,
there's
also
a
link
to
our
office
add-ins
documentation,
as
well
as
our
custom
functions
documentation
in
terms
of
where
you
can
engage
with
us.
If
you
have
questions
about
how
to
do
certain
things
in
various
scenarios,
you
can
reach
out
to
us
on
stackoverflow.com
there's
a
number
of
tags
there
that
you
can
use
for
different
areas
of
office
add-ins.
A
If
you
have
found
a
bug
of
some
sort.
Let
us
know
on
github
at
the
officejs
repo
and
then
that's
why
we
track
all
of
our
bugs
and
if
you
have
feature
requests,
there's
the
uservoice
link
to
go.
Let
us
know
what
scenario
you
need
to
be
unblocked
on
and,
of
course
you
can
always
send
a
smile
of
frown
from
inside
office
itself.
A
This
is
not
the
only
community
call
out
there,
there's
also
others
for
microsoft,
365.
So
if
you're
interested
in
adaptive
cards
or
microsoft,
graph,
microsoft,
identity,
platform,
microsoft
teams,
prior
apps
or
sharepoint,
there's
links
there,
please
go
check
out
those
calls
if
you're
interested
in
any
of
those
areas-
and
you
can
see
a
list
of
all
the
calls
at
the
aka
ms
link
at
the
bottom.
There
m65
down
calls.
A
So
that
brings
us
to
the
end.
So
thanks
everybody
for
attending,
we
will
post
recording
this
soon.
After
on
our
microsoft,
365
developer
youtube
channel.
You
can
also
follow
us
on
twitter,
at
microsoft,
365
dev
and
the
next
call
it's
a
second
wednesday
every
month,
so
it'll
be
november.
11Th
at
8
a.m.
Pacific
daylight
time,
there's
a
link
there.
A
If
you
don't
already
have
the
invite
go
to
that
link
for
the
office,
add-ins
community
call
and
get
the
invite,
and
if
you
have
questions
that
you'd
like
to
us
to
take
a
look
at
ahead
of
time,
please
go
to
the
office.
Add-Ins
form
link.
There
submit
your
questions
and
we'll
take
a
look
at
them.
We
address
them
in
the
q,
a
section
like
we
just
did
so.
Thank
you,
everybody
for
attending,
and
we
will
see
you
on
the
next
call.