Flylib.com
Excel 2003 Programming: A Developers Notebook (Developers Notebook)
Excel 2003 Programming: A Developers Notebook (Developers Notebook)
ISBN: 0596007671
EAN: 2147483647
Year: 2004
Pages: 133
Authors:
Jeff Webb
BUY ON AMAZON
Excel 2003 Programming: A Developer s Notebook
Table of Contents
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
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Excel 2003 Programming: A Developers Notebook (Developers Notebook)
ISBN: 0596007671
EAN: 2147483647
Year: 2004
Pages: 133
Authors:
Jeff Webb
BUY ON AMAZON
Beginners Guide to DarkBASIC Game Programming (Premier Press Game Development)
Introduction to Computer Programming
Basic Graphics Commands
Playing Intro Movies and Cut-Scenes
Fundamentals of 3D Graphics Programming
Appendix A Answers to the Chapter Quizzes
Project Management JumpStart
Building the Foundation
Developing Project Management Skills
Executing the Project
Controlling the Project Outcome
Appendix C Sample Project Management Checklists
The Java Tutorial: A Short Course on the Basics, 4th Edition
First Steps (UNIX/Linux)
How Do These Concepts Translate into Code?
Code Samples
Visual Index to Swing Components
Appendix C. Collections
Practical Intrusion Analysis: Prevention and Detection for the Twenty-First Century: Prevention and Detection for the Twenty-First Century
Understanding Intrusion Detection
Unauthorized Activity I
Unauthorized Activity II
Internet Security Systems RealSecure
The Future of Intrusion Detection and Prevention
Introducing Microsoft ASP.NET AJAX (Pro - Developer)
The AJAX Revolution
The Pulsing Heart of ASP.NET AJAX
Partial Page Rendering
The AJAX Control Toolkit
Built-in Application Services
Cultural Imperative: Global Trends in the 21st Century
Culture and Climate
The Pacific Rim: The Fourth Cultural Ecology
Culture and Globalization
Conclusion
Appendix B Leadership Test
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies