Table of Contents

   
book cover
  
• Table of Contents
• Index
• Reviews
• Examples
• Reader Reviews
• Errata
• Academic
• Performing Web Queries in Excel 2003
Excel 2003 Programming: A Developer's Notebook
By Jeff Webb
 
Publisher: O'Reilly
Pub Date: August 2004
ISBN: 0-596-00767-1
Pages: 312
   


   Copyright
   The Developer's Notebook Series
      Notebooks Are...
      Notebooks Aren't...
      Organization
   Preface
      Don't Force It
      Get the Samples
      Font Conventions
      How to Contact Us
      Acknowledgments
        Chapter 1.  Program the New Excel
      Section 1.1.  Dude, Where's My Data?
      Section 1.2.  How the Pieces Fit
      Section 1.3.  Try It
      Section 1.4.  Kick-Start Lists and XML
      Section 1.5.  Kick-Start SharePoint
      Section 1.6.  Kick-Start Web Services
      Section 1.7.  Kick-Start Security and .NET
      Section 1.8.  Kick-Start InfoPath
      Section 1.9.  What Next?
        Chapter 2.  Share Workspaces and Lists
      Section 2.1.  Get SharePoint Services
      Section 2.2.  Create a Shared Workspace
      Section 2.3.  Share a Workbook
      Section 2.4.  Open a Shared Workbook
      Section 2.5.  Display a SharePoint Site
      Section 2.6.  Remove Sharing
      Section 2.7.  Add Users and Permissions
      Section 2.8.  Allow Anonymous Users
      Section 2.9.  Create a List
      Section 2.10.  Share a List
      Section 2.11.  Update a Shared List
      Section 2.12.  Insert a Shared List
      Section 2.13.  Delete or Unlink a Shared List
      Section 2.14.  Use the Lists Web Service
        Chapter 3.  Work with XML
      Section 3.1.  Speak XML
      Section 3.2.  XML Side-story
      Section 3.3.  Save Workbooks as XML
      Section 3.4.  Transform XML Spreadsheets
      Section 3.5.  Transform XML into a Spreadsheet
      Section 3.6.  Use XML Maps
      Section 3.7.  Exporting Through XML Maps
      Section 3.8.  Use Templates with XML
      Section 3.9.  Respond to XML Events
      Section 3.10.  Program with XML Maps
      Section 3.11.  Get an XML Map from a List or Range
        Chapter 4.  Get Data from the Web
      Section 4.1.  Perform Web Queries
      Section 4.2.  Modify a Web Query
      Section 4.3.  Perform Periodic Updates
      Section 4.4.  Manage Web Queries
      Section 4.5.  Use Web Services
      Section 4.6.  Use the Web Services Toolkit
      Section 4.7.  Use Web Services Through XML
      Section 4.8.  Call a Web Service Asynchronously
      Section 4.9.  Reformat XML Results for Excel
        Chapter 5.  Program Excel with .NET
      Section 5.1.  Work with .NET
      Section 5.2.  Create .NET Components
      Section 5.3.  Use .NET Components
      Section 5.4.  Respond to Errors and Events from .NET
      Section 5.5.  Debug .NET Components
      Section 5.6.  Distribute .NET Components
      Section 5.7.  Use Excel as a Component in .NET
      Section 5.8.  Work with Excel Objects in .NET
      Section 5.9.  Respond to Excel Events in .NET
      Section 5.10.  Respond to Excel Errors in .NET
      Section 5.11.  Distribute .NET Applications That Use Excel
      Section 5.12.  Create Excel .NET Applications
      Section 5.13.  Set .NET Security Policies
      Section 5.14.  Respond to Events in .NET Applications
      Section 5.15.  Debug Excel .NET Applications
      Section 5.16.  Display Windows Forms
      Section 5.17.  Distribute Excel .NET Applications
      Section 5.18.  Distribute Excel .NET Documents
      Section 5.19.  Migrate to .NET
        Chapter 6.  Explore Security in Depth
      Section 6.1.  Dress in Layers
      Section 6.2.  Use Windows Security
      Section 6.3.  Password Protect and Encrypt Workbooks
      Section 6.4.  Program with Passwords and Encryption
      Section 6.5.  Protect Items in a Workbook
      Section 6.6.  Program with Protection
      Section 6.7.  Use Identity-Based Security (a.k.a. IRM)
      Section 6.8.  Program with Permissions
      Section 6.9.  Add Digital Signatures
      Section 6.10.  Set Macro Security
      Section 6.11.  Distribute Security Settings
      Section 6.12.  Common Questions
        Chapter 7.  Build InfoPath Forms
      Section 7.1.  Are InfoPath Forms Better?
      Section 7.2.  InfoPath and Excel
      Section 7.3.  Share Data
      Section 7.4.  Link a Form to a Database
      Section 7.5.  Populate a Control from a Data Source
      Section 7.6.  Validate Data
      Section 7.7.  Link a Form to a Web Service
      Section 7.8.  Script InfoPath
      Section 7.9.  Program InfoPath in .NET
      Section 7.10.  Generate HTML Output
      Section 7.11.  Prevent Design Changes
   About the Author
   Colophon
   Index



Excel 2003 Programming. A Developer's Notebook
Excel 2003 Programming: A Developers Notebook (Developers Notebook)
ISBN: 0596007671
EAN: 2147483647
Year: 2004
Pages: 133
Authors: Jeff Webb

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net