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
CISSP Exam Cram 2
A Note from Series Editor Ed Tittel
About the Author
The Ideal CISSP Candidate
Security Mechanisms
Documents and Guidelines
Building Web Applications with UML (2nd Edition)
Activities
Dynamic Clients
The Vision
Summary
Vision
Making Sense of Change Management: A Complete Guide to the Models, Tools and Techniques of Organizational Change
Part I - The Underpinning Theory
Individual change
Organizational change
Part II - The Applications
Cultural change
The New Solution Selling: The Revolutionary Sales Process That Is Changing the Way People Sell [NEW SOLUTION SELLING 2/E]
Chapter Two Principles
Chapter Four Precall Planning and Research
Chapter Five Stimulating Interest
Chapter Seven Diagnose Before You Prescribe
Chapter Sixteen Creating and Sustaining High-Performance Sales Cultures
Practical Intrusion Analysis: Prevention and Detection for the Twenty-First Century: Prevention and Detection for the Twenty-First Century
Unauthorized Activity II
Internet Security Systems RealSecure
NFR Security
Data Correlation
Security Business Issues
Professional Struts Applications: Building Web Sites with Struts ObjectRelational Bridge, Lucene, and Velocity (Experts Voice)
Creating a Struts-based MVC Application
Form Presentation and Validation with Struts
Templates and Velocity
Creating a Search Engine with Lucene
Building the JavaEdge Application with Ant and Anthill
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