VSTO For Dummies: 完整英文版PDF教程

需积分: 10 167 浏览量更新于2024-07-19 收藏 6.64MB PDF 举报

"VSTO For Dummies 无水印原版pdf" VSTO，全称为Visual Studio Tools for Office，是微软开发的一个工具集，允许开发者利用.NET Framework和Visual Studio来创建、定制和扩展Microsoft Office应用程序，如Word、Excel、PowerPoint和Outlook等。这本书《VSTO For Dummies》由Bill Sempf和Peter Jausovec撰写，旨在为初学者提供一个清晰易懂的指南，帮助他们掌握VSTO开发技术。在VSTO中，开发者可以构建Office解决方案，例如自定义功能区、任务窗格、文档级别的定制以及应用级别的添加-in。这些定制能够极大地提升工作效率，为企业提供定制化的办公环境。通过使用C#或VB.NET编程语言，开发者可以访问Office对象模型，与Office文档交互，执行自动化任务，甚至与后端系统集成。本书的免费Cheat Sheets包含了检查列表、图表、常用指令和其他实用资料，对学习VSTO的初学者来说是非常有价值的参考资料。Dummies.com网站提供了各种资源，包括视频教程、图文并茂的文章、逐步指导，还有机会参与每月的抽奖活动，获取关于数码摄影、Windows和Office、个人金融投资、健康与福祉、计算机与移动设备、互联网、美食、家居与园艺等多个领域的知识。 VSTO的使用范围广泛，从简单的宏自动化到复杂的业务流程集成，都能实现。例如，通过VSTO可以创建一个Excel插件，自动分析数据，生成报表；或者在Word中添加自定义工具，自动格式化文本；还可以在Outlook中构建自定义邮件处理规则，提高邮件管理效率。对于想要深入了解VSTO的读者，可以通过链接www.dummies.com/cheatsheet/vstofd访问专门为本书制作的Cheat Sheet，获取更详细的学习辅助材料。此外，Wiley Publishing, Inc.出版的《VSTO For Dummies》提供了一条深入理解VSTO开发的路径，对于想要在Office环境中拓展功能和提升生产力的开发者来说，是一本不可或缺的参考书籍。

VSTO For Dummies

xiv

Using Excel Controls ...................................................................................130

Using the ListObject control to add data .......................................131

Adding a few more columns .............................................................133

Displaying data on the worksheets .................................................136

Working with Charts in Excel .....................................................................137

Adding a chart the Excel way ...........................................................137

Creating a chart from code ...............................................................139

Chapter 9: Presenting PowerPoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . .141

Introducing PowerPoint ..............................................................................141

Changing the Way PowerPoint Runs .........................................................142

Working with individual panes ........................................................143

Altering a selected item ....................................................................144

Making your selection .......................................................................145

Looking at items different ways .......................................................145

Changing a Presentation Itself ...................................................................145

Changing the design ..........................................................................146

Organizing the slides .........................................................................147

Presenting the slide show .................................................................149

Changing Options ........................................................................................150

Using the Document Inspector ..................................................................150

Adding to PowerPoint .................................................................................151

An Example: Custom Art Selector .............................................................152

Creating a slide template ..................................................................152

Building an add-in ..............................................................................153

Running the example .........................................................................158

Chapter 10: Building an Outlook Job Jar Add-in . . . . . . . . . . . . . . . . .159

Creating a Quick Example of an Outlook Add-in .....................................159

Creating Outlook Items ...............................................................................161

Send me an e-mail ..............................................................................161

Got e-mail? ..........................................................................................162

Oh, I got so much to do. . . . ..............................................................163

Using Form Regions .....................................................................................164

Adding a new Form Region ...............................................................164

Adding controls to the Designer ......................................................168

Building the Job Jar .....................................................................................170

Getting the requirements together ..................................................170

Writing code for your Job Jar ...........................................................171

Setting up the user interface ............................................................172

Running the add-in .............................................................................174

Chapter 11: Creating a Project Project. . . . . . . . . . . . . . . . . . . . . . . . . .177

Breaking Down the Object Model ..............................................................177

Projects ...............................................................................................178

Calendars ............................................................................................179

Resources ...........................................................................................180

Tasks....................................................................................................181

02_046470-ftoc.indd xiv02_046470-ftoc.indd xiv 9/15/10 1:14 PM9/15/10 1:14 PM

Table of Contents

Working Inside Project: An Example .........................................................182

Working with Server ....................................................................................183

Responding to events ........................................................................184

Chapter 12: Developing for Visio. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .185

Exploring Your Visio Development ...........................................................186

Add-ons ...............................................................................................186

VBA ......................................................................................................186

COM add-ins .......................................................................................187

Shared add-ins ....................................................................................187

The Drawing Control .........................................................................187

Visual Studio Tools for Of ce (VSTO) .............................................188

Harnessing the Power of the Visio Model ................................................188

Managing the document and pages .................................................189

Adding basic shapes to a diagram ...................................................190

Adding neat shapes to a diagram ....................................................191

Putting type on the page ...................................................................192

Making data connections ..................................................................193

Saving and exporting the project .....................................................193

Getting Visualization into the Business Process .....................................195

Getting data into that drawing .........................................................195

Making a subroutine to draw the store ...........................................196

Visualizing the product .....................................................................197

Making a button in a toolbar ............................................................198

Running the example .........................................................................199

Part III: Developing for SharePoint ............................ 201

Chapter 13: Working with SharePoint . . . . . . . . . . . . . . . . . . . . . . . . . .203

Getting Started with Microsoft SharePoint Foundation 2010 ................203

Preparing to install SharePoint 2010 ...............................................204

Installing SharePoint prerequisites on Windows 7 ........................206

Installing SharePoint..........................................................................207

Working with SharePoint 2010 Projects in Visual Studio 2010 ..............210

Exploring the SharePoint project structure ...................................211

Taking a closer look at the Feature Designer ...........................................212

Looking at project items ...................................................................214

Meeting the Package Designer .........................................................215

Deploying SharePoint Projects ..................................................................217

Chapter 14: Building SharePoint Workﬂ ows . . . . . . . . . . . . . . . . . . . .221

Starting a Fresh Work ow ..........................................................................221

Knowing What You Have to Work With ....................................................223

Building a Simple Work ow .......................................................................223

Setting the Work ow’s Task Properties ...................................................225

Using a Work ow .........................................................................................226

Verifying Your Work ow ............................................................................227

02_046470-ftoc.indd xv02_046470-ftoc.indd xv 9/15/10 1:14 PM9/15/10 1:14 PM

VSTO For Dummies

xvi

Starting the Work ow .................................................................................228

Managing SharePoint Content Types ........................................................229

Adding a Content Type project ........................................................230

Adding columns .................................................................................231

Referencing columns .........................................................................233

Deploying the solution ......................................................................233

Chapter 15: Building SharePoint Lists and Libraries. . . . . . . . . . . . . .235

Adding a List De nition to a Project .........................................................235

Changing the Startup Item ..........................................................................237

Uploading an Invoice to a Library .............................................................238

Adding Libraries to the Default View ........................................................240

Working with Visual Web Parts .................................................................242

Creating a visual Web part ...............................................................243

Designing controls that work ...........................................................244

Changing your solution type ............................................................248

Deploying your project .....................................................................248

Deploying Files to SharePoint ....................................................................251

Handling Events in SharePoint ...................................................................254

Creating an event receiver ................................................................255

Adding an application page ..............................................................257

Changing the event status ................................................................257

Deploying the event receiver ...........................................................258

Part IV: Finishing Up ................................................ 261

Chapter 16: Security. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .263

Checking Security with CAS .......................................................................263

Creating Test Certi cate Settings ..............................................................264

Generating Manifests and the Trust Prompt ...........................................265

Of ce Trust Center ......................................................................................266

Chapter 17: Deploying VSTO Solutions . . . . . . . . . . . . . . . . . . . . . . . . .269

Getting the Scoop on ClickOnce ................................................................269

Deploying an Add-In with ClickOnce .........................................................270

Adding a reference to the add-in project ........................................271

Deploying the add-in .........................................................................272

Finding additional deployment settings .........................................273

Publishing your add-in ......................................................................275

Updating and testing an add-in ........................................................277

Modifying Additional Settings ....................................................................277

Troubleshooting ..........................................................................................278

VSTO Developer Cleaner...................................................................279

VSTO Troubleshooter .......................................................................279

02_046470-ftoc.indd xvi02_046470-ftoc.indd xvi 9/15/10 1:14 PM9/15/10 1:14 PM

xvii

Table of Contents

Part V: The Part of Tens ............................................ 281

Chapter 18: Ten Reasons to Ditch Web Programming. . . . . . . . . . . . .283

Smart Clients Are Smarter! .........................................................................283

Cross-Platform Needs Are (Often) Overstated ........................................284

You Can Save Time and Money .................................................................284

People Already Know Of ce .......................................................................285

You Can Offer Free Pops and Bangs ..........................................................285

Composite Applications Are the Future ...................................................286

You Have No Cross-Browser Issues ..........................................................286

New Deployment Features Reduce the Hosted Problem .......................287

You Can Combine Windows Forms Features with Your Programs .......287

You Can Better Meet Your Customers Requirements ............................288

Chapter 19: Ten Cool Ideas and Resources for

Your Next VSTO Project . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .289

Create a Macro to Master the Object Model ............................................289

Creating a macro ................................................................................290

Working with your macro’s code .....................................................292

Create Statistics in Outlook ........................................................................294

Protect Your Privacy ...................................................................................295

Create a Four-in-a-Row Game .....................................................................295

Search for Some URLs .................................................................................296

Find Pictures for Your Presentations ........................................................297

Read Word Documents or E-Mails .............................................................297

Remember When Your Favorite Show Is On ............................................298

Try to Make Your Own Treasure Map ......................................................298

Gather Up Resources for Of ce Developers ............................................298

Chapter 20: Ten Ways to Integrate SharePoint. . . . . . . . . . . . . . . . . . .299

Deploy Word or Excel Files with VSTO Automation

to Document Libraries ............................................................................299

Look at the SharePoint 2010 Object Model ..............................................300

Move Documents Around with a Work ow .............................................301

Deploy InfoPath Forms to SharePoint .......................................................301

Integrate Security with a Claims-Based Identity Model ..........................301

Build a PowerPoint Show from SharePoint Site Content ........................302

Use Excel Services in Your VSTO Applications

(and Everywhere Else) ............................................................................302

Index Your Documents ...............................................................................303

Remove Managed Code Extensions from Documents ............................303

Reference SharePoint Services in a VSTO Program ................................304

Index ....................................................................... 305

02_046470-ftoc.indd xvii02_046470-ftoc.indd xvii 9/15/10 1:14 PM9/15/10 1:14 PM

剩余339页未读，继续阅读

yinkaisheng-nj

粉丝: 762
资源: 6231

VSTO For Dummies: 完整英文版PDF教程

VSTO For Dummies pdf

vsto for excel , word on visual studio 2005/2008(2)

vsto2022高级编程.pdf

VSTO for Mere Mortals

VSTO for Mere Mortals [part2]

VSTO for Mere Mortals [part1]

vsto for excel , word on visual studio 2005/2008

VSTO源码教程.pdf

《vsto2005》英文PDF

VSTO_3.0_for_Office_2007_Progr.pdf_pdf_VSTO_ridehmf_源码

最新资源