Excel 2003 Programming : A Developer's Notebook

Jeff Webb

  • 出版商: O'Reilly
  • 出版日期: 2004-09-28
  • 售價: $1,250
  • 貴賓價: 9.5$1,188
  • 語言: 英文
  • 頁數: 314
  • 裝訂: Paperback
  • ISBN: 0596007671
  • ISBN-13: 9780596007676
  • 相關分類: Excel
  • 已過版

買這商品的人也買了...

相關主題

商品描述

Description:

On the surface, it doesn't appear as if much in Excel 2003 has changed. There are a handful of new objects and the user interface is largely the same. But beyond a superficial glance, you'll see that there are fundamental shifts implied by the new features: Lists, XML, web services, .NET, and InfoPath build a framework for entirely new ways to exchange data with Excel. In fact, that's much of what Excel 2003 is all about--solving problems that deal with teamwork-- collecting and sharing data, programming across applications, and maintaining security.

The latest in our Developer's Notebook series, this guide introduces intermediate to advanced Excel VBA programmers to the newest programming features of Excel 2003,--focusing just on what's new--so you can get up to speed quickly. Light on theory and long on practical application, the book takes you directly to the topics you'll want to master through a series of hands-on projects. With dozens of practical labs, you'll be able to decide for yourself which new aspects of Excel will be useful or not in your own work. And best of all, you won't have to buy an expensive revision of a legacy Excel programming tutorial to learn about the new features--if they're covered there at all.

Excel 2003 Programming: A Developer's Notebook shows you how to work with lists and XML data, secure Excel applications, use Visual Studio Tools for Office, consume Web Services, and collect data with Infopath. Each chapter is organized into a collection of labs, each of which addresses a specific programming problem. You can follow along to complete the lab on your own, or jump ahead and use the samples the author has built for you.

The new Developer's Notebooks series from O'Reilly covers important new tools for software developers. Emphasizing example over explanation and practice over theory, they focus on learning by doing--you'll get the goods straight from the masters, in an informal and code-intensive style that suits developers. If you've been curious about Excel 2003, but haven't known where to start, this no-fluff, lab-style guide is the solution.

 

Table of Contents:

The Developer's Notebook Series

Preface

Chapter 1. Program the New Excel
      Dude, Where's My Data?
      How the Pieces Fit
      Try It
      Kick-Start Lists and XML
      Kick-Start SharePoint
      Kick-Start Web Services
      Kick-Start Security and .NET
      Kick-Start InfoPath
      What Next?

Chapter 2. Share Workspaces and Lists
      Get SharePoint Services
      Create a Shared Workspace
      Share a Workbook
      Open a Shared Workbook
      Display a SharePoint Site
      Remove Sharing
      Add Users and Permissions
      Allow Anonymous Users
      Create a List
      Share a List
      Update a Shared List
      Insert a Shared List
      Delete or Unlink a Shared List
      Use the Lists Web Service

Chapter 3. Work with XML
      Speak XML
      XML Side-story
      Save Workbooks as XML
      Transform XML Spreadsheets
      Transform XML into a Spreadsheet
      Use XML Maps
      Exporting Through XML Maps
      Use Templates with XML
      Respond to XML Events
      Program with XML Maps
      Get an XML Map from a List or Range

Chapter 4. Get Data from the Web
      Perform Web Queries
      Modify a Web Query
      Perform Periodic Updates
      Manage Web Queries
      Use Web Services
      Use the Web Services Toolkit
      Use Web Services Through XML
      Call a Web Service Asynchronously
      Reformat XML Results for Excel

Chapter 5. Program Excel with .NET
      Work with .NET
      Create .NET Components
      Use .NET Components
      Respond to Errors and Events from .NET
      Debug .NET Components
      Distribute .NET Components
      Use Excel as a Component in .NET
      Work with Excel Objects in .NET
      Respond to Excel Events in .NET
      Respond to Excel Errors in .NET
      Distribute .NET Applications That Use Excel
      Create Excel .NET Applications
      Set .NET Security Policies
      Respond to Events in .NET Applications
      Debug Excel .NET Applications
      Display Windows Forms
      Distribute Excel .NET Applications
      Distribute Excel .NET Documents
      Migrate to .NET

Chapter 6. Explore Security in Depth
      Dress in Layers
      Use Windows Security
      Password Protect and Encrypt Workbooks
      Program with Passwords and Encryption
      Protect Items in a Workbook
      Program with Protection
      Use Identity-Based Security (a.k.a. IRM)
      Program with Permissions
      Add Digital Signatures
      Set Macro Security
      Distribute Security Settings
      Common Questions

Chapter 7. Build InfoPath Forms
      Are InfoPath Forms Better?
      InfoPath and Excel
      Share Data
      Link a Form to a Database
      Populate a Control from a Data Source
      Validate Data
      Link a Form to a Web Service
      Script InfoPath
      Program InfoPath in .NET
      Generate HTML Output
      Prevent Design Changes

Index