Professional Excel Services

0.0

Excel Services has the potential to revolutionize many industries because Excel 2007 has a number of key investments around UDFs, or User Defined Functions. They revolve around two main areas: allowing UDFs to take advantage of Excel improvements, and extending those UDF-based Excel solutions to the server side with Excel Services.This book instructs readers on how to develop solutions using Excel Services. It covers all facets of programming Excel Services to unlock the power behind the software. To this point, these solutions have definitely been lacking in areas such as running Excel on Excel Client, rewriting Excel models into code, and writing generic solutions for calculating sheets. This book covers ways to use the Services to get around any stumbling blocks. Table of contents : Introduction1. Introduction to Excel Services2. User and Administrator Cheat Sheet3. Inside Excel Services4. Programmability Options5. Hello World Sample6. Excel Web Services Reference7. Building the Excel Services Library (ESL)8. UDF Sample9. UDF Reference10. Client Support for Server UDFs11. Using Excel Web Access. Services Projects12. Utilizing Web Services in UDFs13. Custom Web Services14. RSS Over Excel Services15. Excel Services as an RTD Server16. Real Time Data UDF17. Directly Parameterized Workbooks18. SQL Tables and SharePoint19. External Workbook References20. Excel Services Workflows21. EWA Projects22. Excel Data Filter23. Excel Mashup Market Description : · Primary Audience: The target readership includes SQL Programmers, Report Developers, software integrators, and sophisticated Microsoft Excel Users.· Secondary Audience: Excel users and programmers. About Author : Shahar Prish is originally from Tel-Aviv, Isreal and always dreamed of becoming a Microsoft employee. He worked for a company that developed Data Visualization applications over Analysis Services (MS’s OLAP Server), which was eventually purchased by Microsoft. The company extended job offers to the original employees, and several months later the company shipped Max 3.0, which was re-branded as Microsoft Data Analyzer. After that, Shahar and his family moved from Tel-Aviv to Redmond to work for Microsoft. A few months before work began on the Office 2007 rollout, the concept of an Excel Services server started to form, and Shahar was moved to work specifically on that product development. Throughout the past 5 years, Shahar has worked with some of the best and the brightest to develop the first version of the revolutionary Excel Services. He provides information and previews of Excel Services through his blog: http://blogs.msdn.com/cumgranosalis.