keyur patel @keyurp32 · 2020. 2. 6. · office add-ins let you bring your solution to excel...
TRANSCRIPT
Keyur Patel
@keyurp32
Excel is where users are
Get Data Analyze Visualize Publish Consume
Office Add-ins let you bring your solution to Excel
Connected
Excel should be an
extension of your service.
Not just a copy.
Meet users where they are
Build experiences for Web,
Mac, Mobile and Windows
Smart
Make Excel smarter by
bringing in the rules, logic
for your service.
Add-inAdd-in Add-inAdd-in
Web App Manifest fileAdd-in
Add-in
Web APIs,
Azure services,
cloud storage,
analytics
Office.js
Use Excel JavaScript APIs to get, clean, analyze, visualize data
0
200
400
600
800
1000
1200
1400
1600
1800
2000
1 2 3 4 5 6 7 8 9 10
# A
PIS
API Release
Accelerating towards full API parity
1.9 APIs GA: 500+ NEW APIs!
• Shapes• More Chart Types• AutoFilter• Special Cells• PageLayout• Find and Replace• Copy/Paste Ranges• RangeFormat• PivotTables• Greater Calculation control• Discontiguous Range support• Workbook – Insert, Save and Close
• Small additions to Application, Workbook, Range, Search, Worksheet, and Table
And additional 100+ new APIs coming to Beta soon (Comments, Slicers)!
APIs for every step in the Excel user journey
Get Data Analyze Visualize Publish Consume
Workbook
Range
Worksheet
Table
Rows
Columns
Defined Names
Range Format
Bindings
RangeView
Settings
CustomXmlParts
Protection
Styles
Freeze Pane
Hyperlinks
Create, Save, Close Workbook
Sort
Filter
Sheet Events
Sheet Copy
Table Events
Setting Events
Binding Events
Data Validation
PivotTable
Calc Events
Conditional Formatting
Application/Calculate
Remove Dupes
Charts
Chart Types
Chart Axis
Chart Data Label
Chart Point
Chart Series
Trend Lines
Chart Style
Chart Error Bar
Chart Formatting
Chart Events
Gridlines
Shapes
• Protection
• Sheet Headings
• Gridlines
• Freeze Pane
• Document
Properties
• GetFileAsync
• …across Win32,
Mac, Online, iOS
PUBLIC
Gilbert Karbach, SAP
May 07, 2019
edition for Microsoft Office
96,400+Employees
18,800
+Partners
77%of the world’s
transaction
revenue
92%of the Forbes
Global 2000
€24.74BRevenue
425,000+Customers
Slice and Dice SAP Analytics Cloud models in any Microsoft Office 365 version
Organize your data with Microsoft OfficeSeamless integration into SAP Analytics Cloud reporting and applications
Achieve the freedom of multi-device supportSAP Analytics Cloud add-in supported on any Windows or Apple device
Connect to any SAP Analytics Cloud data sourceFully connected with all SAP Analytics Cloud sources
Future Direction
Demo
Code Example
Extend Excel’s function library
A B C D
1
2 100.19 20.23 5.78
3
=SUM(A2:C2)
SUM
static user data standard formula
Excel functions
A B C D
1
2 100.19 20.23 5.78
3
=CONTOSO.SUM.INV(A2:C2)
CONTOSO.SUM.INV
static user data
Excel custom functions
custom formula
A B C D
1
2 Device1
3
=CONTOSO.STREAMING.LUMENS(B2)
CONTOSO.STREAMING.LUMENS
dynamic user data
Excel streaming custom functions
custom formula
Custom Functions: Scenarios
Custom Functions are now GA on Windows, Mac, Excel Online!
Big thank you to all the developers who gave feedback, tried it out, asked questions during the preview!
© 2019 Bloomberg Finance L.P. All rights reserved.
Bloomberg Office 365
Add-In
Sahil Surana
Senior Software Developer, Core Applications
© 2019 Bloomberg Finance L.P. All rights reserved.
About Bloomberg
The Bloomberg Terminal delivers a diverse array of information on a single platform to facilitate financial decision-making.
© 2019 Bloomberg Finance L.P. All rights reserved.
Bloomberg at a glance
• A technology company, headquartered in NYC
• 325,000+ subscribers in 170 countries
• 5,500+ software engineers
• 120 billion+ pieces of data from the financial markets each day, with a peak of more than 10
million messages per second
• 2 million news stories ingested / published each day (500+ news stories ingested/second)
• Over 1 billion messages and Instant Bloomberg (IB) chats handled daily
• The Bloomberg portfolio consists of the Bloomberg Terminal, Bloomberg News,
Bloomberg Media, Trading Solutions, Enterprise Data, etc.
© 2019 Bloomberg Finance L.P. All rights reserved.
Investment Idea-Generation Process
Portfolio Manager
Research Analysts
Broker - DealersTraders
© 2019 Bloomberg Finance L.P. All rights reserved.
Example Financial Model
© 2019 Bloomberg Finance L.P. All rights reserved.
Portfolio Manager Consumes Information
© 2019 Bloomberg Finance L.P. All rights reserved.
Bloomberg Office 365 Add-in
Demo: Custom Functions
© 2019 Bloomberg Finance L.P. All rights reserved.
© 2019 Bloomberg Finance L.P. All rights reserved.
Bloomberg Office Online Architecture
office.com
Excel Online
AuthenticationCredentials
Token
Validation
Token +
Data Request
Market Data
Bloomberg
Office 365
APIBLPAPI
Data Request
Market Data
© 2019 Bloomberg Finance L.P. All rights reserved.
Custom Functions Batching Demo
Example: https://github.com/OfficeDev/PnP-OfficeAddins/tree/master/Excel-custom-functions/Batching
© 2019 Bloomberg Finance L.P. All rights reserved.
Thank you!
Sahil Surana
Senior Software Developer, Core [email protected]
Have an existing COM or Visual Studio Tools for Office Add-in?
It’s easy to get started
Tools for you
https://aka.ms/getscriptlab
https://aka.ms/office-add-ins-docs
Recap
Time is now
Learn
Engage
What Where
Script Lab https://aka.ms/getscriptlab
Office Add-ins documentation https://aka.ms/office-add-ins-docs
Excel JS API Open spec https://aka.ms/excel-js-open-spec
Custom Functions https://aka.ms/customfunctions
What Where
Stack Overflow (questions) https://stackoverflow.com
office-js
GitHub (issues) https://github.com/OfficeDev/office-js
UserVoice (feature requests) https://officespdev.uservoice.com
Send a Smile or Frown Inside Office
Monthly Community Call https://aka.ms/officeaddinscommunitycall
https://aka.ms/o365devprogram