O'Reilly logo

Programming Excel® Services by Alvin Bruney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

This chapter focused on the holy grail of the Excel Services architecture, the Excel calculation engine. The calculation engine powers Excel Services and exposes myriad functionality to calling applications, including local spreadsheets and remote SOAP clients. The exposure is neatly tucked in under a security umbrella that protects intellectual property, including proprietary formulas and data that might be contained within spreadsheets.

The calculation engine also allows calling code to harvest data based on protected information without exposing the details of the protected information. For instance, an EWS client can use a proprietary formula to perform a calculation request without exposing the intimate details to the client. This ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required