Books & Videos

Table of Contents

  1. Chapter 1 Program the New Excel

    1. Dude, Where’s My Data?

    2. How the Pieces Fit

    3. Try It

    4. Kick-Start Lists and XML

    5. Kick-Start SharePoint

    6. Kick-Start Web Services

    7. Kick-Start Security and .NET

    8. Kick-Start InfoPath

    9. What Next?

  2. Chapter 2 Share Workspaces and Lists

    1. Get SharePoint Services

    2. Create a Shared Workspace

    3. Share a Workbook

    4. Open a Shared Workbook

    5. Display a SharePoint Site

    6. Remove Sharing

    7. Add Users and Permissions

    8. Allow Anonymous Users

    9. Create a List

    10. Share a List

    11. Update a Shared List

    12. Insert a Shared List

    13. Delete or Unlink a Shared List

    14. Use the Lists Web Service

  3. Chapter 3 Work with XML

    1. Speak XML

    2. XML Side-story

    3. Save Workbooks as XML

    4. Transform XML Spreadsheets

    5. Transform XML into a Spreadsheet

    6. Use XML Maps

    7. Exporting Through XML Maps

    8. Use Templates with XML

    9. Respond to XML Events

    10. Program with XML Maps

    11. Get an XML Map from a List or Range

  4. Chapter 4 Get Data from the Web

    1. Perform Web Queries

    2. Modify a Web Query

    3. Perform Periodic Updates

    4. Manage Web Queries

    5. Use Web Services

    6. Use the Web Services Toolkit

    7. Use Web Services Through XML

    8. Call a Web Service Asynchronously

    9. Reformat XML Results for Excel

  5. Chapter 5 Program Excel with .NET

    1. Work with .NET

    2. Create .NET Components

    3. Use .NET Components

    4. Respond to Errors and Events from .NET

    5. Debug .NET Components

    6. Distribute .NET Components

    7. Use Excel as a Component in .NET

    8. Work with Excel Objects in .NET

    9. Respond to Excel Events in .NET

    10. Respond to Excel Errors in .NET

    11. Distribute .NET Applications That Use Excel

    12. Create Excel .NET Applications

    13. Set .NET Security Policies

    14. Respond to Events in .NET Applications

    15. Debug Excel .NET Applications

    16. Display Windows Forms

    17. Distribute Excel .NET Applications

    18. Distribute Excel .NET Documents

    19. Migrate to .NET

  6. Chapter 6 Explore Security in Depth

    1. Dress in Layers

    2. Use Windows Security

    3. Password Protect and Encrypt Workbooks

    4. Program with Passwords and Encryption

    5. Protect Items in a Workbook

    6. Program with Protection

    7. Use Identity-Based Security (a.k.a. IRM)

    8. Program with Permissions

    9. Add Digital Signatures

    10. Set Macro Security

    11. Distribute Security Settings

    12. Common Questions

  7. Chapter 7 Build InfoPath Forms

    1. Are InfoPath Forms Better?

    2. InfoPath and Excel

    3. Share Data

    4. Link a Form to a Database

    5. Populate a Control from a Data Source

    6. Validate Data

    7. Link a Form to a Web Service

    8. Script InfoPath

    9. Program InfoPath in .NET

    10. Generate HTML Output

    11. Prevent Design Changes

  1. Colophon