際際滷

際際滷Share a Scribd company logo
Office Development
      in Visual Studio 2010



Microsoft Indonesia, March 18, 2010



             Andri Yadi | a@dycode.com
          CEO, DyCode | Microsoft MVP, VSTO
       http://geeks.netindonesia.net/blogs/andriyadi
500,000,000
  users on the planet




                        * of鍖ce-watch.com
7.5%
of world population




                      * of鍖ce-watch.com
1%
                                               12%

                                                     2%




                     78%




Microsoft Of鍖ce        WordPerfect                OpenOf鍖ce                 Apple iWork



                  * http://www.webmasterpro.de/portal/news/2010/02/05/international-openof鍖ce-market-shares.html
Do you get the idea?
Huge user base
Familiarity of Office applications
Fluent UI
Easy to extend
Lets see some demo
Sales Tracking, a POC by DyCode
Microsoft Dynamics CRM
Fractal Edge Excel Integration
> Productivity Tools
Uni鍖ed solutions platform
for building Office Business
        Applications
Office 2010 Development in Visual Studio 2010
So, whats the option?
Server and Services connectivity
                                    - Line of business connectivity with BCS
                                    - Web Services & Standards-based interoperability
                                    - Integrate with hosted and on-premises SharePoint
- Evolved developer platform          solutions
   with new services and            Data-oriented development
   extensibility                    - Open XML SDK
                                    - Word, Excel, Access, Project, Visio, InfoPath
- Connected cloud and on-             Services
   premises services to a           - Built on SharePoint Platform Services
   common Office PC, phone          Improved Office Development Experience
   and browser user                 - Fluent UI & Backstage Programmability
   experience
                                    - Easier management with Visual Studio 2010 & .NET
- Developer tools for all skill-      4.0
   levels, from Access to VBA       - Application Compatibility Program
   and Visual Studio                Development tools for everyone
                                    - Simplified InfoPath design
                                    - Access applications published to Web
                                    - Access application usability/design improvements
                                    - Continued commitment to Visual Basic for
                                       Applications (VBA)
UI Extensibility
Backstage View
Its all about your document
What you can do with your
document
Programmable
Backstage - Anatomy
Backstage View ext.
Add new custom tab
Specify layout in custom tab
Hide, disable built-in tabs
RibbonX Customization
Add/remove/move/activate Tabs
Add/remove/move Groups
Create custom groups with built-in
or custom commands
High-Density Layout for custom groups
Save and load customizations from a file
RibbonX - Tab Activation
Programmatically activate a tab
IRibbonUI.ActivateTab(String TabID)

IRibbonUI.ActivateTabMso(TabAddIns)

RibbonCollection.Ribbon1.RibbonUI.Acti
vateTab("MyCustomTab")
RibbonX - Group Scaling
Built-in Ribbon groups change layout as
window resizes
In Office 2010, autoScale property can be
set on a custom group
<group id=Wheel" autoScale="true">
<customUI ...>

 <ribbon> ... </ribbon>

 <contextMenus>                         Context Menu
   <contextMenu idMso="MenuCell">       Extensibility
     <button id="ButtonRefresh .../>   Its customizable
   </contextMenu>                       New control types supported
 </contextMenus>

</customUI>
Backward compatibility (Office
       2007)
       Improved C#
       Improved deployment
!"#"
       More supports on SharePoint +
       Office 2010 integration
Deployment
          VSTOR                PIA


!"#"    Targeting to .NET Framework
       3.5 Full/Client or 4.0 Full/Client
Resources
   Office developer center:
    http://msdn.microsoft.com/office
   Office 2010 developer center:
    http://msdn.microsoft.com/en-us/office/
    ee513173.aspx
   VSTO team blog: http://blogs.msdn.com/vsto/
   How do I video: http://msdn.microsoft.com/en-us/
    vsto/dd164303.aspx
   Office UI Control ID: http://go.microsoft.com/
    fwlink/?LinkID=181052
   Open XML Developer: http://openxmldeveloper.org
Q&A
DyCode
www.dycode.com | of鍖ce@dycode.com
Dynamic IT Solutions for Optimal Business Value

More Related Content

Office 2010 Development in Visual Studio 2010

  • 1. Office Development in Visual Studio 2010 Microsoft Indonesia, March 18, 2010 Andri Yadi | a@dycode.com CEO, DyCode | Microsoft MVP, VSTO http://geeks.netindonesia.net/blogs/andriyadi
  • 2. 500,000,000 users on the planet * of鍖ce-watch.com
  • 3. 7.5% of world population * of鍖ce-watch.com
  • 4. 1% 12% 2% 78% Microsoft Of鍖ce WordPerfect OpenOf鍖ce Apple iWork * http://www.webmasterpro.de/portal/news/2010/02/05/international-openof鍖ce-market-shares.html
  • 5. Do you get the idea?
  • 6. Huge user base Familiarity of Office applications Fluent UI Easy to extend
  • 8. Sales Tracking, a POC by DyCode
  • 10. Fractal Edge Excel Integration
  • 12. Uni鍖ed solutions platform for building Office Business Applications
  • 14. So, whats the option?
  • 15. Server and Services connectivity - Line of business connectivity with BCS - Web Services & Standards-based interoperability - Integrate with hosted and on-premises SharePoint - Evolved developer platform solutions with new services and Data-oriented development extensibility - Open XML SDK - Word, Excel, Access, Project, Visio, InfoPath - Connected cloud and on- Services premises services to a - Built on SharePoint Platform Services common Office PC, phone Improved Office Development Experience and browser user - Fluent UI & Backstage Programmability experience - Easier management with Visual Studio 2010 & .NET - Developer tools for all skill- 4.0 levels, from Access to VBA - Application Compatibility Program and Visual Studio Development tools for everyone - Simplified InfoPath design - Access applications published to Web - Access application usability/design improvements - Continued commitment to Visual Basic for Applications (VBA)
  • 17. Backstage View Its all about your document What you can do with your document Programmable
  • 19. Backstage View ext. Add new custom tab Specify layout in custom tab Hide, disable built-in tabs
  • 20. RibbonX Customization Add/remove/move/activate Tabs Add/remove/move Groups Create custom groups with built-in or custom commands High-Density Layout for custom groups Save and load customizations from a file
  • 21. RibbonX - Tab Activation Programmatically activate a tab IRibbonUI.ActivateTab(String TabID) IRibbonUI.ActivateTabMso(TabAddIns) RibbonCollection.Ribbon1.RibbonUI.Acti vateTab("MyCustomTab")
  • 22. RibbonX - Group Scaling Built-in Ribbon groups change layout as window resizes In Office 2010, autoScale property can be set on a custom group <group id=Wheel" autoScale="true">
  • 23. <customUI ...> <ribbon> ... </ribbon> <contextMenus> Context Menu <contextMenu idMso="MenuCell"> Extensibility <button id="ButtonRefresh .../> Its customizable </contextMenu> New control types supported </contextMenus> </customUI>
  • 24. Backward compatibility (Office 2007) Improved C# Improved deployment !"#" More supports on SharePoint + Office 2010 integration
  • 25. Deployment VSTOR PIA !"#" Targeting to .NET Framework 3.5 Full/Client or 4.0 Full/Client
  • 26. Resources Office developer center: http://msdn.microsoft.com/office Office 2010 developer center: http://msdn.microsoft.com/en-us/office/ ee513173.aspx VSTO team blog: http://blogs.msdn.com/vsto/ How do I video: http://msdn.microsoft.com/en-us/ vsto/dd164303.aspx Office UI Control ID: http://go.microsoft.com/ fwlink/?LinkID=181052 Open XML Developer: http://openxmldeveloper.org
  • 27. Q&A
  • 28. DyCode www.dycode.com | of鍖ce@dycode.com Dynamic IT Solutions for Optimal Business Value