Programming Excel Services

by Alvin J. Bruney

Learn how to use Excel Services to add spreadsheets and workbooks to your enterprise dashboards and portals. You get real-world examples and code samples to help you enable business intelligence on... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0735624070
• ISBN13: 9780735624078
• Release Date: June 2007
• Publisher: Microsoft Press
• Length: 313 Pages
• Weight: 1.50 lbs.
• Dimensions: 1.0" x 7.4" x 8.9"

Customer Reviews

Programming Excel Services

Perhaps you would like to know what you get when you buy this book. Here is a detailed overview. Chapter 1 is an introduction aimed at decision makers. You won't find code there. This chapter simply tells the story of MOSS and its evolution. It presents an argument on why I think you need to consider Excel Services as an enterprise solution. It also outlines what you need to watch out for with regard to installation, licensing and other thorny issues that you won't find on MSDN. Chapter 2 thru 5 lay the foundation of Excel services. I talk in-depth about the Excel Web Service, Calculation Engine, Excel Web Parts. I show you how to use the new tools such as the extensions for Visual Studio that help you to build web parts. There is code on at least every page. That's how I like it. I mix the code with a good dose of theory, but at the end of the day, this book is code heavy. Period. Chapter 6 lays it on thick. If you don't have a solid foundation, you shouldn't even bother tackling this chapter. In there, I show you how to embed objects into web parts to include managed and unmanaged objects such as charts, spreadsheets and other types of objects. I walk you thru the process of embedding managed usercontrols into web parts so that you can automate desktop objects thru web parts. For instance, if you want to place your favorite windows control in a web part on SharePoint, I show you how to do this through code. I focus on advanced web part programming as well to include real-time object automation and so on and so forth. In my research leading up to this chapter, I've not seen any examples of this type of programming out there. I'd like to point out that I worked closely with MS Support in figuring out how to do this stuff because initially, they didn't think that it could be done. What's in this chapter will amaze you. Chapter 7 starts where chapter 6 trails off, that is, uphill. Steep! The focus of Chapter 7 is to show how the SharePoint product can be consumed by ASP.NET. I tackle the difficult subjects such as Code Access Security issues around web parts and User Defined Functions and show you how to properly configure embedded managed controls in web parts. SharePoint features provide in-depth probes of the architecture. Want to do AJAX with Web Parts? Microsoft recommends against it, but I show you how to do it safely within the confines of the SharePoint architecture. Want to learn to fire an event on MOSS 2007 and transition that event so that it is caught in script running in the browser? I show you how to do that and how this is different from plain-jane SharePoint eventing. Want to learn how to automate an Office application on the desktop from a Web Part? Didn't think it was possible? Go ahead, try chapter 7. It's real code. Working examples. New concepts. I round off the advanced pieces with a deep-dive into SharePoint Web Part connections. Have you seen the pages of code posted on MSDN to build connected Web Parts? Why should