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
SQL Tips & Techniques (Miscellaneous)
Working with Queries, Expressions, and Aggregate Functions
Performing Multiple-table Queries and Creating SQL Data Views
Writing External Applications to Query and Manipulate Database Data
Working with Stored Procedures
Writing Advanced Queries and Subqueries
A Practitioners Guide to Software Test Design
Case Studies
Section I - Black Box Testing Techniques
Decision Table Testing
State-Transition Testing
Domain Analysis Testing
Cisco IOS in a Nutshell (In a Nutshell (OReilly))
The Routers Configuration
System Banners
Asynchronous Interfaces
Neighbor Authentication
A.3. IPv6
Programming Microsoft ASP.NET 3.5
Web Forms Internals
The ADO.NET Object Model
Real-World Data Access
ASP.NET Security
Index
Lean Six Sigma for Service : How to Use Lean Speed and Six Sigma Quality to Improve Services and Transactions
Seeing Services Through Your Customers Eyes-Becoming a customer-centered organization
Success Story #2 Bank One Bigger… Now Better
Success Story #3 Fort Wayne, Indiana From 0 to 60 in nothing flat
Phase 1 Readiness Assessment
Phase 2 Engagement (Creating Pull)
Java Concurrency in Practice
Benefits of Threads
What is Thread Safety?
Delegating Thread Safety
Choosing Between Synchronized and ReentrantLock
Appendix A. Annotations for Concurrency
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