PROFESSIONAL VSTO 2005: VISUAL STUDIO 2005 TOOLS FOR OFFICE
CONTENTS CHAPTER 1: VISUAL STUDIO TOOLS FOR OFFICE WHAT’S NEW IN VSTO? VSTO ARCHITECTURE USER INTERFACE CLIENT INTERFACE SERVER COMPONENT THE VSTO PACKAGE ABOUT MICROSOFT OFFICE PIAS SYSTEM REQUIREMENTS ALTERNATIVES TO THE VSTO OFFICE SYSTEMS VBA OFFICE WEB COMPONENTS EXCEL COM INTEROP LIBRARIES THIRD PARTY PRODUCTS DISADVANTAGES OF VSTO NET FRAMEWORK REQUIRED SECURITY PERFORMANCE VSTO AUTOMATION OFFICE XML SCHEMAS INSTALLATION AND DEPLOYMENT CREATING VSTO PROJECTS VSTO INSTALLATION ISSUES SUMMARY CHAPTER 2: EXCEL AUTOMATION EXCEL DATA MANIPULATION DESIGN-TIME DATA LOADS LOADING FILES AT RUNTIME APPLICATION OBJECT MANIPULATION WORKBOOK MANIPULATION WORKSHEET MANIPULATION EXCEL RANGE MANIPULATION WORKING WITH NAMED RANGES WORKING WITH CELLS WORKING WITH UNIONS WORKING WITH INTERSECTIONS WORKING WITH OFFSETS DATA FORMATTING AND PRESENTATION CONSIDERATIONS FOR EXCEL AUTOMATION EXCEL CASE STUDY — TIME SHEET SOFTWARE CHAPTER 3: ADVANCED EXCEL AUTOMATION VSTO SECURITY WORKBOOK PASSWORD PROTECTION WORKSHEET SECURITY PROTECTION THROUGH HIDDEN WORKSHEETS PROTECTING RANGES VSTO SECURITY THROUGH THE NET FRAMEWORK WORKING WITH EXCEL FORMULAS USING FORMULAS AT DESIGN TIME USING FORMULAS AT RUNTIME WORKING WITH THE WORKSHEETFUNCTIONS METHOD EXCEL SPREADSHEET ERROR VALUES RESPONDING TO EVENTS WORKING WITH WORKBOOK CONTROLS THE RANGE CONTROL THE LIST CONTROL THE ACTIONS PANE PRINTING WORKBOOK DATA EXCEL TOOLBAR CUSTOMIZATION EXCEL MENU CUSTOMIZATION VSTO AND WEB SERVICES EXCEL SERVER AUTOMATION EXCEL COM ADD-INS CHAPTER 4: WORD AUTOMATION KEY APPLICATION OBJECTS IN WORD THISAPPLICATION INSTANCE WORKING WITH THE RANGE OBJECT WORKING WITH THE BOOKMARK OBJECT WORKING WITH THE SELECTION OBJECT VSTO TABLE MANIPULATION WORKING WITH DOCUMENTS MANIPULATING OFFICE DOCUMENTS WORKING WITH WORD TEMPLATES TOOLBAR CUSTOMIZATION MENU CUSTOMIZATION WORKING WITH OTHER OFFICE APPLICATIONS A POWERPOINT AUTOMATION EXAMPLE AN OFFICE AUTOMATION EXECUTABLE EXAMPLE A SMART TAG EXAMPLE MANIPULATING OFFICE CONTROLS WORD EVENT MODEL PRINTING DOCUMENTS FROM WORD CONSIDERATIONS FOR WORD DEVELOPMENT PIAS AND RCWS FOR OFFICE WORD ASSEMBLIES AND DEPLOYMENT CUSTOM ACTIONS PANES CHAPTER 5: OUTLOOK AUTOMATION CONFIGURING VSTO OUTLOOK KEY OUTLOOK OBJECTS WHAT IS MAPI? APPLICATION OBJECT EXPLORER OBJECT INSPECTOR OBJECT EMAIL INTEGRATION CREATING EMAILS MANIPULATING EMAIL MESSAGES APPOINTMENTS AND MEETINGS CREATING AND SCHEDULING APPOINTMENTS DELETING APPOINTMENTS CREATING MEETINGS CREATING AND SCHEDULING OUTLOOK ITEMS FOLDER MANIPULATION ADDRESS BOOK MANIPULATION EVENTS DATA MANIPULATION SEARCHING FOR DATA ADVANCED DATA SEARCH WORKING WITH OFFICE CONTROLS INTEGRATING WINDOWS APPLICATIONS WITH OUTLOOK CHAPTER 6: THE CHARTING TOOL DESIGN-TIME CHARTING CHART WIZARD CHARTING NOMENCLATURE CREATING VSTO CHARTS STAND-ALONE CHARTS EMBEDDED CHARTS LOADING CHARTS WITH DATA ESSENTIAL CHART OBJECT HIERARCHY SERIES MANIPULATION AXES AND SCALING TICK MARKS TITLES AND CAPTIONS CHART GROUPS FORMATTING CHART DATA FONT OBJECT CUSTOMIZATIONS NUMBER FORMAT CUSTOMIZATION CHART SURFACE CUSTOMIZATION CHART LEGEND MANIPULATION ANALYSING DATA TRENDING THROUGH TREND LINES INTERNALLY SUPPORTED TRENDLINES CUSTOM TRENDLINES ERROR BAR ANALYSIS CHART CUSTOMIZATION THROUGH EVENTS ADVANCED CHART MANIPULATION CHARTS WITH MULTIPLE SERIES COMBINATION CHARTS PERSPECTIVES AND 3-D DRAWING CHART POINT CUSTOMIZATION ADDING OBJECTS TO THE CHART SURFACE CHARTS WITH SPECIAL NEEDS CHART LIMITATIONS CHAPTER 7: PIVOT TABLE AUTOMATION DESIGN-TIME PIVOTING VSTO PIVOTTABLE WIZARD PIVOTING AND DRILLING PIVOT TABLE TERMINOLOGY PIVOTCACHE OBJECT PIVOTDATA OBJECTS PIVOT AXIS PIVOT FIELDS PIVOT CELL OBJECT PIVOT LABELS CREATING PIVOT TABLES THROUGH CODE FORMATTING PIVOT DATA LABEL FORMAT CUSTOMIZATION STYLE OBJECT CUSTOMIZATION DATA FORMATTING WITH NUMBERFORMATS PIVOT AXIS ITERATION PIVOT FILTERING ADDING MISCELLANEOUS COLUMNS PIVOT TABLE EVENTS CREATING PIVOT CHARTS PIVOT TABLE LIMITATIONS