Did you ever wonder whether there is more to Excel than data displayed in rows and columns or pretty charts? If you want to learn how to bring data into your Excel 2007 projects, or learn to work with XML, or see how object-oriented programming can be used in Excel 2007, this book will provide you with that information.
I wrote this book because I’ve always enjoyed writing applications in Excel when it is the required solution. Excel is often overlooked in coding situations, but as you’ll see in the pages of this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 has expanded XML support. XML data is easily brought into and out of an Excel project so your client spreadsheet data can be shared. Excel UserForms give you the ability to create simple user interfaces for your clients and allow you to create easy-to-use data collection tools. Excel charting and PivotTables have always been a strong suit for data summary, and in Excel 2007, PivotTables are greatly enhanced.
This book also addresses object-oriented programming to a great degree. Just because you’re not writing a .NET or even a classic Visual Basic application, there’s no reason you can’t use object-oriented coding techniques in your projects. It provides you with the same advantages in Excel that you get in the full-fledged programming languages: ease of reuse, easier code maintenance, encapsulation, and more.
You will find sample files and code solutions in the Source Code/Download section of the Apress web site, at www.apress.com.
XML in a Nutshell, Third Edition There's a lot to know about XML, and it s constantly evolving. But you don't need to commit every syntax, API, or XSLT transformation to memory; you only need to know where to find it. And if it's a detail that has to do with XML or its companion standards, you'll find it--clear, concise, useful, and well-organized--in the updated third... Principles of Digital Communication
The renowned communications theorist Robert Gallager brings his lucid writing style to the study of the fundamental system aspects of digital communication for a one-semester course for graduate students. With the clarity and insight that have characterized his teaching and earlier textbooks, he develops a simple framework and then combines...
Android in Action
When we set out to write the first version of this book, many friends and family wondered just what this Android thing was all about. Now, two years after the publication of the first edition, Android is nearly a household term.
The first edition of the book, Unlocking Android, enjoyed enough success that we were privileged to have...
Mad About Modern Physics : Braintwisters, Paradoxes, and Curiosities This book of almost 250 puzzles begins where our first book, Mad
About Physics: Braintwisters, Paradoxes, and Curiosities (2001)
ended—with the physics of the late nineteenth and early twentieth
centuries. The Michelson-Morley experiment of 1887, the
challenges posed by atomic spectra and blackbody radiation, the
Maya: Secrets of the Pros In this unique full-color book, a cadre of professionals led by Maya expert and best-selling author, John Kundert-Gibbs, team up to share what they’ve learned using Maya in the CG trenches.
Contributing authors include veterans of such high-profiles projects as The Lord of the Rings trilogy, Final Fantasy: The Spirits...