Two new books about Excel Services are out


These two Excel Services books are out (or will very soon be). I decided to use this space to shamelessly promote them! 🙂


The first book is called “Beginning Excel Services” and is written by Liviu, Eran and Craig. I have been working with Liviu for about 8 years now and with Eran for close to 12 years. I have worked with Craig for about 3-4 years on Excel Services. All three are incredibly professional and this book should be the corner-stone for anybody wanting to deploy Excel Services. As a bonus, this book will probably become a collectors item in the next few years as this is the only known picture of Liviu (left-most in the picture) where he’s actually smiling.






Beginning Excel Services explains what Excel Services is, what are the benefits and how to get started. The book starts from the basics, and shows you how to deploy an evaluation copy of Excel Services. It then goes into various aspects of the architecture, performance and capacity planning, security and protecting the information, deployment and administration, and bringing in external data into worksheets. The last part of the book has detailed step by step chapters that guide you through each scenario. These include publishing workbooks to the server, controlling the distribution of workbooks, reporting, interacting with data and business intelligence.

The second book (“Professional Excel Services“) is by yours truely (yes, that’s my ugly mug on the cover – I told Wrox that having my picture on the cover will hurt sales, but they didnt listen),






Professional Excel Services is all about the Excel Services developer – the first part will explain all about the internals of Excel Services, will go through all the programming options that Excel Services provides. This includes detailed information about UDFs and Excel Web Services, but it also contains information about common “gotchas” and about the reasoning behind some of the features. The second part goes through a dozen or so examples showing various solutions that can be done by using Excel Services – most of them reusable and generic enough that they can be used in almost any solution. Through these examples, the book shows how to use not only Excel Services UDFs and Excel Web Services, but also AJAX, SharePoint, Workflow and Excel Client technologies.

Comments (10)

  1. sanderton says:

    Hi,

    Are you the Sahar Prish who wrote eTivo?

    Stuart

  2. Shahar says:

    Nope.

    I do recall writing EtiVo though ;). It was a long time ago.. Before my kid, my work and the book monopolized my time completely.

    And the xbox360……

    s

  3. Stuart says:

    Capital letters in the middle of proper names – Apple has a lot to answer for!

    I know quite a few of us who still use EtiVo 🙂 would like to continue its development – at the least iron out a couple of minor bugs –  if you’d care to make the source code available?

    Stuart

  4. Shahar says:

    Hey Stuart,

    Lets take this offline – contact me via this link: http://blogs.msdn.com/cumgranosalis/contact.aspx and we can continue the conversation there.

  5. Imran says:

    Hi Shahar,

    I am thrilled by Excel Services, and I see lot of future for it. Infact, that is what I made a comment in a GoldCoast Usergroup meeting. I am working on an Excel Services idea that can be sold to my company. Something that is worth for other company. I could not find a way to do what-if analysis with Excel Service + Analysis Service + Cube. I am sure there must be a way to do. I plan to explore these books. Let me know if you come towards South Florida for some Excel  Services Demo.

    Cheers,

    Imran

  6. Shahar says:

    Imran,

    I dont think Excel Services supports AS based what-if analysis. All you can do is Excel-based What-if analysis by using parameters (or the WS API).

  7. Vinay says:

    Hi Shahar,

       I got the "Professional Excel Services" book.  In the chapter "Building ESL", you mention that ExcelServicesLibrary code is in companion CD, but there is not CD with the book. Also, ESL code is not part of all code on wrox.com. Can you please upload it on your blog (here) so that it can be downloaded.

    Thanks,

    Vinay.

  8. Timo says:

    The ExcelServicesLibrary is within the book section ESL. You have to code by yourself.

    I do not understand why not all code is within the code download. This makes me sad as well. Not everythink is easy if I try to follow. Sometimes it is easier read code side by side with the book. If you make mistakes in your code your are alonge. In general good book but this is a big negativ point.

  9. Imran says:

    Shahar,

    You may be right that What-if analysis is not support out of box. However, there is work around using Excel formulas. I used that to track project schedules and cost. It works great. Management can view progress of the project and plug values to see what-if.

    I am trying to recover my blog. I plan to write it soon. Happy Holidays.

    Cheers,

    Imran

  10. Boris Frenkel says:

    Is the source code for ExcelServicesLibrary available for download anywhere?