Description
Book SynopsisLight on theory and long on practical application, this guide takes you directly to Excel 2003's new features using a series of hands-on projects. Learn to work with lists and XML data, secure Excel applications, use Visual Studio Tools for Office, consume Web Services, and collect data with Infopath.
Table of ContentsPreface 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
